Received: from malur.postgresql.org ([217.196.149.56])
	by arkaria.postgresql.org with esmtps  (TLS1.3) tls
 TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384
	(Exim 4.94.2)
	(envelope-from <pgsql-hackers-owner+archive@lists.postgresql.org>)
	id 1sZB6b-00Guq2-MI
	for pgsql-hackers@arkaria.postgresql.org; Wed, 31 Jul 2024 15:19:09 +0000
Received: from localhost ([127.0.0.1] helo=malur.postgresql.org)
	by malur.postgresql.org with esmtp (Exim 4.94.2)
	(envelope-from <pgsql-hackers-owner+archive@lists.postgresql.org>)
	id 1sZB6Z-0090ue-Pc
	for pgsql-hackers@arkaria.postgresql.org; Wed, 31 Jul 2024 15:19:07 +0000
Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29])
	by malur.postgresql.org with esmtps  (TLS1.3) tls
 TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384
	(Exim 4.94.2)
	(envelope-from <nathandbossart@gmail.com>)
	id 1sZB6Z-0090t2-FM
	for pgsql-hackers@lists.postgresql.org; Wed, 31 Jul 2024 15:19:07 +0000
Received: from mail-io1-xd2c.google.com ([2607:f8b0:4864:20::d2c])
	by magus.postgresql.org with esmtps  (TLS1.3) tls
 TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256
	(Exim 4.94.2)
	(envelope-from <nathandbossart@gmail.com>)
	id 1sZB6X-002SJe-1R
	for pgsql-hackers@postgresql.org; Wed, 31 Jul 2024 15:19:06 +0000
Received: by mail-io1-xd2c.google.com with SMTP id
 ca18e2360f4ac-8076cee8088so224226839f.0
        for <pgsql-hackers@postgresql.org>;
 Wed, 31 Jul 2024 08:19:04 -0700 (PDT)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
        d=gmail.com; s=20230601; t=1722439143; x=1723043943;
 darn=postgresql.org;
        h=in-reply-to:content-disposition:mime-version:references:message-id
         :subject:cc:to:from:date:from:to:cc:subject:date:message-id:reply-to;
        bh=39PIA72d8ZlGWFJY+vRitN4j7KmveightchgWhVIIwM=;
        b=Z6CUEx9Ldol8XMVw6NLTTElMGghmvu8RPEe5LcnaFuwDEigKlb6ZmXRaV//0tgwY8Y
         ZLVdAMGBnVq23EcSwT9maLIOrppT/Ext0cSICWGP3QlasHveNEeKsRljFxKFtJPW05j6
         OE+xhddR8S+NMfRgm3qVYj9Tzwh2fMmeeNbdWoy7mCchKcMpuXuQQNSEJQzxQJfnJY80
         4nLTZw4F2n4sdtZ19/lJ+86u+q9wNuOTO6aLaSpdykaiFdfkRAkemFhF6sbaAfbbVYpR
         qs+bhQEP3am3h/AArshWn7f4fqwLdx1pdOf1x8twONDrhiqRZNN8QzuxTbM2WyzFwuqK
         W7DA==
X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
        d=1e100.net; s=20230601; t=1722439143; x=1723043943;
        h=in-reply-to:content-disposition:mime-version:references:message-id
         :subject:cc:to:from:date:x-gm-message-state:from:to:cc:subject:date
         :message-id:reply-to;
        bh=39PIA72d8ZlGWFJY+vRitN4j7KmveightchgWhVIIwM=;
        b=DEqAphdutI0REqo7tNrDd+JkGZyiEwUmsJ5t8H3c0QsWmz4rgF2At52+EbIy/epj6j
         UGmngkLuxuYAYPQpxfzqrjTYu9OBdg4tEWjDC33mqVpLSsSVGPmEm88ZywSCyV05r2J7
         PDnPnfRQQ1OLJWeaxocBWh6ZsXEv9mt9NJX0suZ6eizxbO9pW+93cZxrJfl0vZtbESlx
         yrke2kRs0uyXvUjNqDlzdIl6tPFeR2ugq0Xe6wh3NVkrvSdHK+AplafiuIodC/ODZJkp
         zRNKpRx3GauVFHc9QePbU5Qj0V0Z5DoxzYj+aGmXxHCS2rphif6y6sHIDM2m9tQY6sFQ
         U0IQ==
X-Forwarded-Encrypted: i=1;
 AJvYcCUzfuAPhAGGkawBrJC7TJ6qT0uP0gjfFftkY3ije8XJI78Fv53LSNwtirbq7IihROZ+OzsO46eaXBOns9TSdHtCRBDbtBCWU2PdIzSB
X-Gm-Message-State: AOJu0YxIRgClN2sWKK/sJJk9b1NXJylpl2K8i9jDPF4NvJuTp3swXanV
	T0niGPN+Q4RRxDzIPiYol28anM8rkW6I2nc144wreFGeVgQIIv/4/ngn7Q==
X-Google-Smtp-Source: 
 AGHT+IHjpoClaWiNwJ+CuZ91VZS3ypiei+cEYBtoT63P/SWdgOhi4EBuzk+HSJPN6aSVyxIMNaplhw==
X-Received: by 2002:a05:6602:610b:b0:81f:9f79:2b37 with SMTP id
 ca18e2360f4ac-81f9f792cc8mr1255062439f.16.1722439143265;
        Wed, 31 Jul 2024 08:19:03 -0700 (PDT)
Received: from nathan (162-195-168-172.lightspeed.stlsmo.sbcglobal.net.
 [162.195.168.172])
        by smtp.gmail.com with ESMTPSA id
 8926c6da1cb9f-4c29fa93398sm3245828173.45.2024.07.31.08.19.02
        (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256);
        Wed, 31 Jul 2024 08:19:02 -0700 (PDT)
Date: Wed, 31 Jul 2024 10:19:01 -0500
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>
Subject: Re: improve performance of pg_dump with many sequences
Message-ID: <ZqpV5Sb7YWauwYnx@nathan>
References: <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>
 <ZqFJspSbieuTE4X0@nathan>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
In-Reply-To: <ZqFJspSbieuTE4X0@nathan>
List-Id: <pgsql-hackers.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:pgsql-hackers@lists.postgresql.org>
List-Owner: <mailto:pgsql-hackers-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/pgsql-hackers>
Archived-At: <https://www.postgresql.org/message-id/ZqpV5Sb7YWauwYnx%40nathan>
Precedence: bulk

Committed.

-- 
nathan