PostgreSQL 19 Beta 1 Released with Incremental Materialized Views, JSON Enhancements, and Performance Improvements
By
PostgreSQL Global Development Group
Pulled from the oven just right. Trustworthy, fact-dense, deeply satisfying.
Summary
The PostgreSQL Global Development Group has released the first beta of PostgreSQL 19, featuring previews of new capabilities ahead of general availability. Key highlights include improved query performance with incremental materialized view maintenance, enhanced partitioning with UNIQUE and PRIMARY KEY support on partitioned tables, and better JSON functionality with SQL/JSON constructor and query functions. The release also introduces performance improvements for vacuum operations, logical replication, and I/O, along with security enhancements like TLS certificate updates and new authentication parameters. The community encourages testing during the beta period to help finalize the release.
Key quotes
· 3 pulledIn the spirit of the open source PostgreSQL community, we strongly encourage you to test the new features of PostgreSQL 19 on your systems to help improve the quality and stability of the release.
PostgreSQL 19 includes incremental materialized view maintenance, which can significantly improve query performance by only refreshing the data that has changed since the last refresh.
PostgreSQL 19 adds SQL/JSON constructor functions and SQL/JSON query functions to improve the developer experience when working with JSON data.
You might also wanna read
Postgres 19 Adds Native Temporal Table Support: A Deep Dive into SQL:2011 Features
Postgres 19 is introducing native temporal table support based on the SQL:2011 standard, allowing users to query what data looked like at sp
pgedge.com·18h ago
PostgreSQL 18 Introduces UUIDv7 Support for Improved Database Performance
This article explores PostgreSQL 18's new UUIDv7 support, explaining how UUIDv7 addresses performance issues associated with traditional UUI
aiven.io·8mo ago
PostgreSQL 18 Adds Native UUIDv7 Support for Improved Index Performance
PostgreSQL 18 introduces native support for UUIDv7, a timestamp-based UUID variant that offers better performance with btree indexes compare
thenile.dev·8mo ago
pg_lake: PostgreSQL Extension for Iceberg and Data Lake Integration
pg_lake is a PostgreSQL extension developed by Snowflake Labs that enables Postgres to function as a lakehouse system by integrating with Ic
github.com·7mo ago
pg_jitter: Lightweight JIT Compilation Provider for PostgreSQL with Alternative Backends
pg_jitter is a lightweight JIT compilation provider for PostgreSQL that offers three alternative JIT backends (sljit, AsmJit, and MIR) as al
github.com·3mo ago
PostgreSQL 18 Introduces Pipelining Support in psql Client
This article explains pipelining in PostgreSQL 18, a client-side feature that allows sending multiple queries to the server without waiting