pg.ddx.io  pgsql-hackers@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: Nathan Bossart <nathandbossart@gmail.com>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: Michael Paquier <michael@paquier.xyz>
Cc: Euler Taveira <euler@eulerto.com>
Cc: pgsql-hackers <pgsql-hackers@postgresql.org>
Subject: Re: improve performance of pg_dump with many sequences
Date: Wed, 24 Jul 2024 13:36:34 -0500
Message-ID: <ZqFJspSbieuTE4X0@nathan> (raw)
In-Reply-To: <Zpl7HywbF2qAkTVf@nathan>
References: <ZpcsrAcClLt7AwdI@paquier.xyz>
	<Zpc5HGb7yDfTNDy5@nathan>
	<ZpgR4OMpbekeja_n@nathan>
	<3578088.1721242766@sss.pgh.pa.us>
	<ZpgV32NTM0ADvJop@nathan>
	<3585715.1721243507@sss.pgh.pa.us>
	<ZpiP3I6UVcgsCCWf@nathan>
	<3640163.1721275101@sss.pgh.pa.us>
	<ZpldUoP0XjHszExF@nathan>
	<Zpl7HywbF2qAkTVf@nathan>

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





view thread (32+ messages)  latest in thread

Message-ID: <ZqFJspSbieuTE4X0@nathan>
Permalink:  ../ZqFJspSbieuTE4X0@nathan/
Also on:    postgresql.org/message-id/ZqFJspSbieuTE4X0@nathan

 · 

reply
Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-hackers@postgresql.org
  Cc: nathandbossart@gmail.com, tgl@sss.pgh.pa.us, michael@paquier.xyz, euler@eulerto.com
  Subject: Re: improve performance of pg_dump with many sequences
  In-Reply-To: <ZqFJspSbieuTE4X0@nathan>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox