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
|
Список | 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 по дате отправления: