Do not lock tables in get_tables_to_repack

The discussion concerns a proposed change to pg_repack's `get_tables_to_repack` function. The author (cca5507) notes that during whole-database repacks, locks taken on tables to p…

Read Discussion

Handle concurrent drop when doing whole database vacuum

The discussion addresses handling concurrent relation drops during whole-database VACUUM. A v5 patch has been shared and received an LGTM from Bharath Rupireddy. A minor suggestio…

Read Discussion

Move FOR PORTION OF checks out of analysis

Peter Eisentraut reviewed Paul A Jungwirth's patches (v9/v10) for moving FOR PORTION OF checks out of analysis. Patch 0002, which moves the volatile check into the planner, was co…

Read Discussion

Why clearing the VM doesn't require registering vm buffer in wal record

The thread discusses a bug fix related to visibility map (VM) buffer registration in WAL records. Robert Haas noted that patches appeared based on an old commit and requested a re…

Read Discussion

DDL deparse

The discussion centers on DDL deparse design for PostgreSQL, particularly around preserving user intent versus generating replication-friendly output. Masahiko Sawada and Vitaly D…

Read Discussion

Proposal: Conflict log history table for Logical Replication

The discussion continues refining the conflict log history table (CLT) for logical replication. Key updates include: using `json` instead of `jsonb` for tuple columns (`remote_tup…

Read Discussion

PGNexus Daily News

PostgreSQL Hackers Email Discussion Highlights

Social Media Updates