PGNexus Daily News

PostgreSQL Hackers Email Discussion Highlights

RI fast path gets cross-type foreign keys wrong

Peter Geoghegan reported a bug in the RI fast path (introduced by commit b7b27eb41, affecting PostgreSQL 19 and master) where cross-type foreign key equality operators produce inc…

Read Discussion
Recovery conflict resolution misses backends that import snapshots

The discussion addresses a bug where recovery conflict resolution on standbys misses backends that import snapshots. Scott Ray submitted a v2 patch responding to feedback from Ami…

Read Discussion
[PATCH] Fix timeline history after recovery stops on an ancestor

Stepan Filippov reported a bug where PostgreSQL generates an incorrect timeline history file during PITR. When archive recovery stops on an ancestor timeline before reaching recov…

Read Discussion
WAL compression setting after PostgreSQL LZ4 default change

The discussion concerns changing PostgreSQL's default WAL compression algorithm from pglz to lz4 (or possibly zstd) for PG19. Tomas Vondra raised this with the Release Management…

Read Discussion

Social Media Updates

linkedin

Ready to build something new with Databricks?

Databricks is hosting a virtual AMER Learning Festival on August 19–20, featuring hands-on sessions on Lakebase, SQL analytics and BI, and data warehousing. Attendees will learn f…

Want to stay up to date with the PostgreSQL community and industry news?
Visit PGNexus to learn more