Re: Use COPY for populating all pgbench tables

From: "Tristan Partin" <tristan(at)neon(dot)tech>
To: "Michael Paquier" <michael(at)paquier(dot)xyz>
Cc: <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Use COPY for populating all pgbench tables
Date: 2023-07-19 18:01:29
Message-ID: CU6CG3VTYTHS.148RQZ0NOMC12@gonk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-hackers

On Wed Jul 12, 2023 at 10:52 PM CDT, Michael Paquier wrote:
> 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.
> >
> > 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?


I think I completely misunderstood you. From what I can tell, you want
to use FREEZE wherever possible. I think the new patch covers your
comment and fixes the documentation. I am hoping that I have finally
gotten what you are looking for.

Tristan Partin
Neon (

Attachment Content-Type Size
v4-0001-Use-COPY-instead-of-INSERT-for-populating-all-tab.patch text/x-patch 7.8 KB

In response to


Browse pgsql-hackers by date

  From Date Subject
Next Message Tristan Partin 2023-07-19 18:03:21 Re: Use COPY for populating all pgbench tables
Previous Message Pavel Luzanov 2023-07-19 17:44:36 Re: psql: Add role's membership options to the \du+ command