Re: improve performance of pg_dump with many sequences

Nathan Bossart <nathandbossart@gmail.com>

From: Nathan Bossart <nathandbossart@gmail.com>

To: Tom Lane <tgl@sss.pgh.pa.us>

Cc: Michael Paquier <michael@paquier.xyz>, Euler Taveira <euler@eulerto.com>, pgsql-hackers <pgsql-hackers@postgresql.org>

Date: 2026-01-09T16:17:12Z

Lists: pgsql-hackers

On Thu, Jan 08, 2026 at 02:54:53PM -0500, Tom Lane wrote:
> WFM.

Thanks, committed.

-- 
nathan

Commits

pg_dump: Fix gathering of sequence information.
- 7a485bd641b7 19 (unreleased) landed
- 39d55557661f 18.2 landed
Improve performance of dumpSequence().
- 68e962998598 18.0 landed
Improve performance of dumpSequenceData().
- bd15b7db489d 18.0 landed
Introduce pg_sequence_read_tuple().
- c8b06bb969bf 18.0 landed
Parse sequence type and integer metadata in dumpSequence().
- 23687e925f94 18.0 landed