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%20cros...> 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%20cros...> Recovery conflict resolution misses backends that import snapshots <https://pgnexus.ai/hacker-discussions?subject=Recovery%20conflict%20resoluti...> 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%20resoluti...> [PATCH] Fix timeline history after recovery stops on an ancestor <https://pgnexus.ai/hacker-discussions?subject=%5BPATCH%5D%20Fix%20timeline%2...> 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%2...> WAL compression setting after PostgreSQL LZ4 default change <https://pgnexus.ai/hacker-discussions?subject=WAL%20compression%20setting%20...> 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%20...> Social Media Updates linkedin Ready to build something new with Databricks? <https://pgnexus.ai/social-media?url=https%3A%2F%2Fwww.linkedin.com%2Fposts%2...> 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