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

Поиск
Список
Период
Сортировка
От Robert Haas
Тема Re: Re: reloption to prevent VACUUM from truncating empty pages atthe end of relation
Дата
Msg-id CA+TgmoZCAfbv5c38ehTu24zxvWAR3CPvUKHB2_yTrsa8ai8gaw@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Re: reloption to prevent VACUUM from truncating empty pages atthe end of relation  (Julien Rouhaud <rjuju123@gmail.com>)
Ответы Re: Re: reloption to prevent VACUUM from truncating empty pages atthe end of relation  (Andrew Dunstan <andrew.dunstan@2ndquadrant.com>)
Список pgsql-hackers
Дерево обсуждения 
On Fri, Apr 5, 2019 at 2:11 PM Julien Rouhaud <rjuju123@gmail.com> wrote:
> > My preference is for "truncate" over "shrink".
>
> I don't really like "shrink" either, but users already have problems
> to get the difference between VACUUM and VACUUM FULL, I'm afraid that
> "VACUUM TRUNCATE_TABLE" will just make things worse.

That's not the proposed syntax, though.  What you'd end up writing is
something like VACUUM (TRUNCATE OFF) myrel.

-- 
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company

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

Предыдущее
От: Julien Rouhaud
Дата:
Сообщение: Re: Re: reloption to prevent VACUUM from truncating empty pages atthe end of relation
Следующее
От: Adrien Mobile
Дата:
Сообщение: Re: Re: reloption to prevent VACUUM from truncating empty pages at the end of relation