Re: Using COPY FREEZE in pgbench

Hello Tatsuo-san,

> 13.2 pgbench + master branch server:
> done in 15.47 s (drop tables 0.19 s, create tables 0.01 s, client-side generate 9.07 s, vacuum 2.07 s, primary keys 4.13 s).
>
> With patch on master branch:
> done in 13.38 s (drop tables 0.19 s, create tables 0.01 s, client-side generate 9.68 s, vacuum 0.23 s, primary keys 3.27 s).

Yes, this is the kind of figures I got on my laptop.

> This time current pgbench performs much faster than I wrote (15.47 s vs.
> 70.78 s). I don't why.

Duno.

> Anyway, this time total pgbench time is reduced by 14% over all
> here. I hope people agree that the patch is worth the gain.

Yes, because (1) why not take +10% and (2) it exercises an option.

--
Fabien.