PostgreSQL 19, the Open-Source Database, Arrives: Strengthening Operations and Query Stability
1 day ago / Read about 0 minute
Author:小编   

On November 19, 2026 (local time), the open-source relational database PostgreSQL 19 was officially released. This version focuses on operational efficiency, query execution stability, and ease of data operations, introducing multiple commands, extensions, and SQL capabilities: it introduces the REPACK (CONCURRENTLY) command, which can reorganize tablespaces without blocking; enhances query plan stability through the pg_plan_advice extension; optimizes capabilities related to logical replication and asynchronous I/O; adds WAIT FOR LSN to ensure read-write consistency; adds INSERT ON CONFLICT DO SELECT to simplify data processing in conflict scenarios; and adds IGNORE NULLS support to window functions. In terms of performance, foreign key checks have been optimized, and batch insert speed has nearly doubled. This version does not support direct overwrite installation; users need to migrate via pg_upgrade or pg_dumpall.