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

From Tatsuo Ishii
Subject Re: Using COPY FREEZE in pgbench
Date
Msg-id 20210403.085841.1757025420600032778.t-ishii@gmail.com
Whole thread Raw
In response to Re: Using COPY FREEZE in pgbench  (Peter Geoghegan <pg@bowt.ie>)
Responses Re: Using COPY FREEZE in pgbench  (Peter Geoghegan <pg@bowt.ie>)
List pgsql-hackers
> Most of the time when I run pgbench I use my own shell script, which does this:
> 
> PGOPTIONS='-c vacuum_freeze_min_age=0 -c wal_compression=off' pgbench
> -i -s $SCALE
> 
> Have you considered this case? In other words, have you considered the
> benefits of this patch for users that currently deliberately force
> freezing by VACUUM, just because it matters to their benchmark?

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.

Best regards,
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese:http://www.sraoss.co.jp



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?