PGNexus Daily News PostgreSQL Hackers Email Discussion Highlights Is there value in having optimizer stats for joins/foreignkeys? <https://pgnexus.ai/hacker-discussions?subject=Is%20there%20value%20in%20havi...> Tomas Vondra reviewed the v9 patch set for join/foreign-key optimizer statistics. He considers patches 0001, 0002, and 0004 nearly committable, with 0004 recommended to be reorder… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=Is%20there%20value%20in%20havi...> [PATCH] Release replication slot on error in SQL-callable slot functions <https://pgnexus.ai/hacker-discussions?subject=%5BPATCH%5D%20Release%20replic...> The discussion concerns a patch to release replication slots on error in SQL-callable slot functions. Ashutosh Sharma raised a concern about `AtEOSubXact_ReplicationSlot()`: when… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=%5BPATCH%5D%20Release%20replic...> WAL compression setting after PostgreSQL LZ4 default change <https://pgnexus.ai/hacker-discussions?subject=WAL%20compression%20setting%20...> The discussion concerns what algorithm the WAL compression setting `on` should map to, following PostgreSQL's change to default LZ4 compression. Tomas Vondra had noted one benchma… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=WAL%20compression%20setting%20...> Revisiting {CREATE INDEX, REINDEX} CONCURRENTLY improvements <https://pgnexus.ai/hacker-discussions?subject=Revisiting%20%7BCREATE%20INDEX...> Mikhail Nikalayeu posted v38 of a patch series improving CREATE INDEX CONCURRENTLY and REINDEX CONCURRENTLY. The key change in this version is that STIR (the concurrent indexing m… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=Revisiting%20%7BCREATE%20INDEX...> Adding pg_dump flag for parallel export to pipes <https://pgnexus.ai/hacker-discussions?subject=Adding%20pg_dump%20flag%20for%...> A patch series adding a `--pipe` flag to `pg_dump` for parallel export to pipes (without an intermediate dump directory) has been reviewed and tested. The tester verified error ha… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=Adding%20pg_dump%20flag%20for%...> Proposal: Conflict log history table for Logical Replication <https://pgnexus.ai/hacker-discussions?subject=Proposal%3A%20Conflict%20log%2...> The discussion concerns a proposed Conflict Log Table (CLT) for PostgreSQL logical replication. The central debate is whether the CLT should log all conflicts (including those han… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=Proposal%3A%20Conflict%20log%2...> Click here for the full Hacker discussion highlights <https://pgnexus.ai/daily-updates?file=2026-08-08-postgresql-daily-news-232.m...> Want to stay up to date with the PostgreSQL community and industry news? Visit PGNexus <https://pgnexus.ai> to learn more