pg_dump: Fetch sequence data only for sequences being dumped

Edit
ID 7350
Title pg_dump: Fetch sequence data only for sequences being dumped
CI (CFBot) Summary
Stats (from CFBot) Patch version: v1, Patch count: 1, First patch: +56−20, All patches: +56−20
Tags Backport Bugfix Performance
Created 2026-09-26 19:08:43
Last modified 2026-09-26 19:08:43 (59 minutes ago)
Latest email 2026-09-26 19:01:29 (1 hour ago)
Status
PG20-3 (2026-11-01 – 2026-11-30): Needs review
Target version
Authors Andrew Krylosov (krylosov-aa)
Reviewers Become reviewer
Committer
Links
Emails
BUG #19688: pg_dump --schema scans all sequences in PostgreSQL 18, causing severe performance regression
First at 2026-09-14 20:49:46 by PG Bug reporting form <noreply at postgresql.org>
Latest at 2026-09-26 19:01:29 by Andrew Krylosov <krylosov.andrew at gmail.com>
Latest attachment (v1_PG18-0001-pg_dump-Fetch-sequence-data-only-for-sequences-be.patch.txt) at 2026-09-26 19:01:29 from Andrew Krylosov <krylosov.andrew at gmail.com>
    Attachment (v1_PG18-0001-pg_dump-Fetch-sequence-data-only-for-sequences-be.patch.txt) at 2026-09-26 19:01:29 from Andrew Krylosov <krylosov.andrew at gmail.com> (Patch: No)
History
When Who What
2026-09-26 19:08:43 Andrew Krylosov (krylosov-aa) Attached mail thread 19688-e90025dc375a22a3@postgresql.org
2026-09-26 19:08:43 Andrew Krylosov (krylosov-aa) Created patch record
Edit