hacking.postgres.tv
./menu

postgres=# select * from projects where slug = 'pg-dump-table-data-placeholders';

pg_dump table-data placeholders

Keep loadable slots for excluded table data so replacement data is restored before dependent indexes and constraints.

needs review[-hackers patch ↗][first review ↗]

current state

needs review

blocker: The first review raised interface questions; the patch needs a revised option design and another version.

next

  • Settle the command-line and filter-file interface
  • Post the next patch version
  • Add a CommitFest entry when ready

sessions

1
· 77:12 · youtube ↗

Agent hacking Postgres

Agent-assisted patch work around the wait-event timing submission.

The group reviewed Kirk Wolak's pg_dump patch for keeping loadable placeholders when table data is excluded, grounding the discussion in his large-table restore workflow. They debated a positive interface, filter-file actions, arbitrary dump queries, PII transformation, and referential-integrity risks, then posted supportive review feedback to pgsql-hackers. The final segment examined Salma El-Sayed's B-tree leaf-page merge design, including merged-page markers, scan correctness, vacuum cleanup, and review plans.

[timecodes · 8]
  1. Postgres 19 development opens and patches await review
  2. Kirk introduces the pg_dump placeholder patch
  3. Large-table dump and one-command restore use case
  4. Reviewing the option name and user interface
  5. Using AI to review design and mailing-list history
  6. Parallel chunks for restoring one large table
  7. Custom dump queries, filtering, and PII transformation
  8. B-tree leaf-page merge design and scan safety
#wait events#B-tree#AI-assisted hacking#hacking process@Nikolay Samokhvalov@Andrey Borodin@Kirk Wolak
-hackersCF #6984
active

correlated mapping