Feedback-ID: i0fe9450f:Fastmail
Date: Thu, 13 Jul 2023 12:52:49 +0900
From: Michael Paquier <michael@paquier.xyz>
To: Tristan Partin <tristan@neon.tech>
Cc: pgsql-hackers@postgresql.org
Subject: Re: Use COPY for populating all pgbench tables
Message-ID: <ZK91ET3oYP2OMfDI@paquier.xyz>
References: <CSTU5P82ONZ1.19XFUGHMXHBRY@c3po>
 <CTCG9VOM6GJ4.3NDBRQ7U4EP4Z@gonk>
 <CTCHWOCZ9X8Z.1PDXVDUXZ3D0P@gonk>
 <ZKzik5uamTwRWHsY@paquier.xyz>
 <CTZFAQT1PDPQ.30VM4JHGNU3J@gonk>
 <ZK5C26HdJlRJ/yOl@paquier.xyz>
 <CU09K8PHEOIZ.I5NPQDPOQ1SO@gonk>
MIME-Version: 1.0
Content-Type: multipart/signed; micalg=pgp-sha512;
	protocol="application/pgp-signature"; boundary="BwGbaTwLFH7+oT0C"
Content-Disposition: inline
In-Reply-To: <CU09K8PHEOIZ.I5NPQDPOQ1SO@gonk>
Archived-At: 
 <https://www.postgresql.org/message-id/ZK91ET3oYP2OMfDI%40paquier.xyz>
Precedence: bulk


--BwGbaTwLFH7+oT0C
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
Content-Transfer-Encoding: quoted-printable

On Wed, Jul 12, 2023 at 09:29:35AM -0500, Tristan Partin wrote:
> On Wed Jul 12, 2023 at 1:06 AM CDT, Michael Paquier wrote:
>> This would use the freeze option only on pgbench_accounts when no
>> partitioning is defined, but my point was a bit different.  We could
>> use the FREEZE option on the teller and branch tables as well, no?
>> Okay, the impact is limited compared to accounts in terms of amount of
>> data loaded, but perhaps some people like playing with large scaling
>> factors where this could show a benefit in the initial data loading.
>=20
> Perhaps, should they all be keyed off the same option? Seemed like in
> your previous comment you wanted multiple options. Sorry for not reading
> your comment correctly.

I would have though that --partition should only apply to the
pgbench_accounts table, while FREEZE should apply where it is possible
to use it, aka all the COPY queries except when pgbench_accounts is a
partition.  Would you do something different, like not applying FREEZE
to pgbench_tellers and pgbench_branches as these have much less tuples
than pgbench_accounts?
--
Michael

--BwGbaTwLFH7+oT0C
Content-Type: application/pgp-signature; name="signature.asc"

-----BEGIN PGP SIGNATURE-----

iQIzBAABCgAdFiEEG72nH6vTowiyblFKnvQgOdbyQH0FAmSvdREACgkQnvQgOdby
QH39bRAAiSfMJFxvaVsLeY+LDG5XyK35bWsCCDGWZTCyPsooIxAP1vPvVQybGamd
LPEf1M55/92aK/UdiHRp8B5erGZDf2aEYqqy+U6Afgo4/82Sx1ntyYGApAkjbl5u
+cydWnH7Aj7AiCuDuNPdP/qYW8PfxiNQY3FikL63JGp/KcXV65p3BHx7kuacGA7F
+Se1W592iduxxqJbFM1vV6rjDBeSrMhI6zGzKsTA+wowLBIPjgpS0uQl35185FYp
DrV+oHzhx8EGWKrG3SG/dSDS0pJ5rZQlzEkd6d5syW3Q4EWxj6bdoIl5D2hUrlpl
AvPeWK2NGkMVr7qAL19yQOkOEodVjm5isXB1HT5OEc38nHAP3RW8LPkcnIgcCjhs
ZvvkCciKizHQx5IaiicTlPbWo/Uz3+Q0XaL/ui7yV7HUpcXtp6fn5LqkzyKobaS2
nUui2KVDudJRETFpU7Q8UwUT5dW+pdDYoLpNrl5FB6vHq6oimSB59gxKjt1jDzlu
IJnoo2csMTGhnYjwPwTJDT8crpZ+2d+iuuluITbormgzsuJcvBDfe/O/B8fhMaMm
aQC2CoJ8rWnGT/x8TgMvtIl6gFsSppklmUQ/JGOIBdOWHLkNz9gQENDJLH2q2gh3
NA98Fw9Hrw+HEwbBVIDRaMQJ3zXmgm6wzpaD3an6U+7WdfSd+C4=
=W0jN
-----END PGP SIGNATURE-----

--BwGbaTwLFH7+oT0C--