PGNexus Daily News

PostgreSQL Hackers Email Discussion Highlights

Is there value in having optimizer stats for joins/foreignkeys?

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
[PATCH] Release replication slot on error in SQL-callable slot functions

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
WAL compression setting after PostgreSQL LZ4 default change

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
Revisiting {CREATE INDEX, REINDEX} CONCURRENTLY improvements

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
Adding pg_dump flag for parallel export to pipes

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
Proposal: Conflict log history table for Logical Replication

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

Click here for the full Hacker discussion highlights

 

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