A naukri.com initiative
Cloudblog
2M
321
Image Credit: Cloudblog
What’s new in PostgreSQL 17, now available in Cloud SQL
- Cloud SQL now supports PostgreSQL 17, offering a range of new features and enhancements in security, developer experience, performance, tooling, and observability.
- PostgreSQL 17 introduces the MAINTAIN privilege, offering a more granular level of control over database maintenance tasks with predefined role called pg_maintain.
- The MERGE command is a powerful addition that simplifies data manipulation and improves performance.
- JSON_TABLE function introduces a more intuitive way to convert JSON data into a standard table format, unlike earlier methods.
- PostgreSQL 17 introduces new, more efficient TidStore to store tuple IDs during VACUUM operations, reducing significantly memory consumption.
- Improvement to the ReadBuffer API in PostgreSQL 17 introduces reading multiple consecutive blocks from disk into shared buffers with one system call, benefiting workloads that involve reading multiple blocks.
- PostgreSQL 17 introduces the --filter option in pg_dump, pg_dumpall, pg_restore, providing more fine-grained control over what objects are included or excluded in the dump or restore operation.
- The new pg_wait_events system view provides information about events causing processes to wait and identify performance bottlenecks and troubleshooting database issues.
- The pg_stat_checkpointer system view provides information related to the checkpoint process, allowing you to monitor and analyze checkpoint performance.
- Cloud SQL PostgreSQL 17 is available on Google Cloud, with significant advancements that streamline database operations and improve management capabilities.
Read Full Article
19 Likes
For uninterrupted reading, download the app