Pgtechdailyen

By thread

pgtechdailyen@ivorysql.org

August 2026

1 participants
31 messages

PGNexus Daily News #225 2026-08-01

by pgnexus

PGNexus Daily News PostgreSQL Hackers Email Discussion Highlights RI fast path gets cross-type foreign keys wrong <https://pgnexus.ai/hacker-discussions?subject=RI%20fast%20path%20gets%20cro…> 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 <https://pgnexus.ai/hacker-discussions?subject=RI%20fast%20path%20gets%20cro…> Recovery conflict resolution misses backends that import snapshots <https://pgnexus.ai/hacker-discussions?subject=Recovery%20conflict%20resolut…> 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 <https://pgnexus.ai/hacker-discussions?subject=Recovery%20conflict%20resolut…> [PATCH] Fix timeline history after recovery stops on an ancestor <https://pgnexus.ai/hacker-discussions?subject=%5BPATCH%5D%20Fix%20timeline%…> 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 <https://pgnexus.ai/hacker-discussions?subject=%5BPATCH%5D%20Fix%20timeline%…> WAL compression setting after PostgreSQL LZ4 default change <https://pgnexus.ai/hacker-discussions?subject=WAL%20compression%20setting%2…> 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 <https://pgnexus.ai/hacker-discussions?subject=WAL%20compression%20setting%2…> Social Media Updates linkedin Ready to build something new with Databricks? <https://pgnexus.ai/social-media?url=https%3A%2F%2Fwww.linkedin.com%2Fposts%…> 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 <https://pgnexus.ai> to learn more

Aug. 1, 2026