Re: Re: reloption to prevent VACUUM from truncating empty pages atthe end of relation

Поиск
Список
Период
Сортировка
От Fujii Masao
Тема Re: Re: reloption to prevent VACUUM from truncating empty pages atthe end of relation
Дата
Msg-id CAHGQGwFkAnB6MKhDih15=JBn=HgyLSEJnXZHzosgao8B7wUTOA@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Re: reloption to prevent VACUUM from truncating empty pages atthe end of relation  (Robert Haas <robertmhaas@gmail.com>)
Ответы Re: Re: reloption to prevent VACUUM from truncating empty pages atthe end of relation  (Masahiko Sawada <sawada.mshk@gmail.com>)
Re: reloption to prevent VACUUM from truncating empty pages at theend of relation  (Andres Freund <andres@anarazel.de>)
Список pgsql-hackers
On Sat, Apr 6, 2019 at 2:04 AM Robert Haas <robertmhaas@gmail.com> wrote:
>
> On Thu, Apr 4, 2019 at 9:19 PM Masahiko Sawada <sawada.mshk@gmail.com> wrote:
> > As INDEX_CLEANUP option has been added by commit a96c41f, the new
> > option for this feature could also accept zero or one boolean
> > argument, that is SHRINK_TABLE [true|false] and true by default.
> > Explicit options on VACUUM command overwrite options set by
> > reloptions. And if the boolean argument is omitted the option depends
> > on the reloptions.
>
> Yes, I think that's how it should work, because that's how the other
> option works, and there's no compelling reason to be consistent.
>
> My preference is for "truncate" over "shrink".

+1

Attached is the updated version of the patch.
I just replaced "shrink" with "truncate" and rebased the patch
on the master. I'm thinking to commit this patch at first.
We can change the term and add the support of "TRUNCATE" option
for VACUUM command later.

Regards,

-- 
Fujii Masao

Вложения

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

Предыдущее
От: Justin Pryzby
Дата:
Сообщение: Cleanup/remove/update references to OID column
Следующее
От: Masahiko Sawada
Дата:
Сообщение: Re: Re: reloption to prevent VACUUM from truncating empty pages atthe end of relation