pg_dump: Fetch sequence data only for sequences being dumped

Title

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 (1 month ago)

Latest email

2026-09-26 19:01:29 (1 month ago)

Status

PG20-3 (2026-11-01 – 2026-11-30): Needs review

Target version

Authors

Andrew Krylosov (krylosov-aa)

Reviewers

Diego - (galponcio), Surya Poondla (spoondla), Christopher Bell (bellcr) Log in to 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-11-09 21:51:55	Surya Poondla (spoondla)	Added spoondla as reviewer
2026-11-06 16:54:55	Diego - (galponcio)	Added galponcio as reviewer
2026-11-05 20:40:00	Christopher Bell (bellcr)	Added bellcr as reviewer
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