From: | Tatsuo Ishii <ishii(at)sraoss(dot)co(dot)jp> |
---|---|
To: | coelho(at)cri(dot)ensmp(dot)fr |
Cc: | pgsql-hackers(at)lists(dot)postgresql(dot)org |
Subject: | Re: Using COPY FREEZE in pgbench |
Date: | 2021-03-21 09:30:59 |
Message-ID: | 20210321.183059.1674023631327092084.t-ishii@sraoss.co.jp |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
> The feature is a little disappointing because if someone has partition
> tables then probably they have a lot of data and probably they would
> like freeze to work there. Maybe freeze would work on table partitions
> themselves, but I do not think it is worth the effort to do that.
Agreed.
> About v4 there is a typo in the doc "portioning":
>
> <command>pgbench</command> uses FREEZE option with 14 or later
> version of <productname>PostgreSQL</productname> to speed up
> subsequent <command>VACUUM</command> if portioning option is not
> specified.
>
> I'd suggest:
>
> <command>pgbench</command> uses the FREEZE option with 14 or later
> version of <productname>PostgreSQL</productname> to speed up
> subsequent <command>VACUUM</command>, unless partitions are enabled.
Thanks for pointing it out. Also I think that in "with 14 or later
version", "version" should be "versions".
Attached is the v5 patch.
Best regards,
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese:http://www.sraoss.co.jp
Attachment | Content-Type | Size |
---|---|---|
pgbench_freeze_v5.diff | text/x-patch | 2.0 KB |
From | Date | Subject | |
---|---|---|---|
Next Message | Pavel Stehule | 2021-03-21 09:37:36 | Re: proposal - psql - use pager for \watch command |
Previous Message | Gilles Darold | 2021-03-21 09:21:17 | Re: [PATCH] proposal for regexp_count, regexp_instr, regexp_substr and regexp_replace |