Re: Using COPY FREEZE in pgbench

Поиск
Список
Период
Сортировка
От Fabien COELHO
Тема Re: Using COPY FREEZE in pgbench
Дата
Msg-id alpine.DEB.2.22.394.2103210933310.1912353@pseudo
обсуждение исходный текст
Ответ на Re: Using COPY FREEZE in pgbench  (Tatsuo Ishii <ishii@sraoss.co.jp>)
Ответы Re: Using COPY FREEZE in pgbench  (Tatsuo Ishii <ishii@sraoss.co.jp>)
Список pgsql-hackers
>>> V3 works for me and looks ok. I changed it to ready in the CF app.
>>
>> Thank you for your review!
>
> Unfortunately it seems cfbot is not happy with the patch.

Argh. Indeed, I did not thought of testing on a partitioned table:-( ISTM 
I did "make check" in pgbench to trigger tap tests, but possibly it was in 
a dream:-(

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.

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.

-- 
Fabien.



В списке pgsql-hackers по дате отправления:

Предыдущее
От: Noah Misch
Дата:
Сообщение: Re: cleaning up a few CLOG-related things
Следующее
От: Markus Wanner
Дата:
Сообщение: Re: Logical Replication vs. 2PC