Re: Using COPY FREEZE in pgbench - Mailing list pgsql-hackers

From Peter Geoghegan
Subject Re: Using COPY FREEZE in pgbench
Date
Msg-id CAH2-Wz=7DtyDSmvPTiUgeCPhDw4KGwVva2SygKPaiLmj8TwjXQ@mail.gmail.com
Whole thread Raw
In response to Re: Using COPY FREEZE in pgbench  (Tatsuo Ishii <ishii@sraoss.co.jp>)
Responses Re: Using COPY FREEZE in pgbench  (Tatsuo Ishii <ishii@sraoss.co.jp>)
List pgsql-hackers
On Fri, Apr 2, 2021 at 4:58 PM Tatsuo Ishii <ishii@sraoss.co.jp> wrote:
> I am not sure how many people use this kind of options while running
> pgbench -i but we could add yet another switch to fall back to none
> FREEZE COPY if you want.

I was unclear. What I meant was that your patch isn't just useful
because it speeds up "pgbench -i" for everybody. It's also useful
because having all of the tuples already frozen after bulk loading
seems like a good benchmarking practice, at least most of the time.

The patch changes the initial state of the database with "pgbench -i",
I think. But that's good.

-- 
Peter Geoghegan



pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: Have I found an interval arithmetic bug?
Next
From: Zhihong Yu
Date:
Subject: Re: Have I found an interval arithmetic bug?