Re: Using COPY FREEZE in pgbench

From: Fabien COELHO <coelho(at)cri(dot)ensmp(dot)fr>
To: Tatsuo Ishii <ishii(at)sraoss(dot)co(dot)jp>
Cc: PostgreSQL Developers <pgsql-hackers(at)lists(dot)postgresql(dot)org>
Subject: Re: Using COPY FREEZE in pgbench
Date: 2021-03-21 16:30:57
Message-ID: alpine.DEB.2.22.394.2103211204230.1912353@pseudo
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers


> Attached is the v5 patch.

About v5: doc gen ok, global and local make check ok.

I did a few tests on my laptop. Is seems that copying takes a little more
time, say about 10%, but vacuum is indeed very significantly reduced, so
that the total time for copying and vacuuming is reduced by 10% on
overall.

So it is okay for me.

--
Fabien.

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Gilles Darold 2021-03-21 16:40:45 Re: [PATCH] proposal for regexp_count, regexp_instr, regexp_substr and regexp_replace
Previous Message Tom Lane 2021-03-21 16:27:22 Re: "has_column_privilege()" issue with attnums and non-existent columns