Toolsslug: postgresql-19

PostgreSQL 19

Latest major release of the open-source relational database, focused on online operational control and logical replication enhan

Curated Intelligence

3 items · Page 1/1
Hacker News AIT2·Open Source
58 pts
PostgreSQL 19 Ships REPACK Command and Logical Replication Upgrades

PostgreSQL 19 is released with a new REPACK command that reclaims disk space and reorganizes table contents, with a CONCURRENTLY mode that avoids blocking reads and writes. It also adds the pg_plan_advice and pg_stash_advice extensions for planner control, enables logical replication without a server restart, supports sequence-value replication, and adds read-your-writes consistency on standbys.

Hacker News AIT2·Tools
58 pts
PostgreSQL 19 Ships with Same-Day Support on Databricks Lakebase

PostgreSQL 19 reached GA and is available on Databricks Lakebase the same day, skipping the usual weeks-long lag for managed services. The release centers on operational control: online REPACK, query plan advice, and WAIT FOR LSN for read-your-writes on replicas, plus logical replication upgrades. Several Lakebase engineers are PostgreSQL committers who contributed directly to the release.

Simon Willison 博客T2·Tools
58 pts
PostgreSQL 19 Ships with Read-Your-Writes Consistency via WAIT FOR LSN

PostgreSQL 19 has shipped roughly two months later than its usual September cadence, largely because the team had to work through a surge of AI-assisted vulnerability reports. The headline feature is the new WAIT FOR LSN command, which lets a standby session wait until WAL replay reaches a given LSN before querying, enabling read-your-writes consistency on read replicas.