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: 2024-07-24T18:36:34Z

Lists: pgsql-hackers

I ran Euler's tests again on the v6 patch set.

	for i in `seq 1 10000`; do psql postgres -c "CREATE SEQUENCE s$i;"; done
	time pg_dump -f - -s -d postgres > /dev/null

	HEAD:        0.607s
	0001 + 0002: 0.094s
	all patches: 0.094s

Barring additional feedback, I am planning to commit these patches early
next week.

-- 
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