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

Поиск
Список
Период
Сортировка
От Darafei Praliaskouski
Тема Re: reloption to prevent VACUUM from truncating empty pages at the end of relation
Дата
Msg-id 155453718772.16480.8982498117656778884.pgcf@coridan.postgresql.org
обсуждение исходный текст
Ответ на Re: Re: reloption to prevent VACUUM from truncating empty pages atthe end of relation  (Robert Haas <robertmhaas@gmail.com>)
Список pgsql-hackers
The following review has been posted through the commitfest application:
make installcheck-world:  not tested
Implements feature:       not tested
Spec compliant:           not tested
Documentation:            not tested

I have read disable-vacuum-truncation_v6.patch.

I like it the way it is.

Word "truncation" for me means "remove everything from the table" (as in TRUNCATE) and I don't want VACUUM to do that
:),shrink feels appropriate. 
 
TRIM has a connotation from SSD drives, where you can discard blocks in the middle of your data and let the underlying
infrastructurehandle space allocation on it.
 
Please keep it for the good times Postgres can punch a hole in the middle of relation and let filesystem handle that
space.

The new status of this patch is: Ready for Committer

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

Предыдущее
От: GUO Rui
Дата:
Сообщение: Re: Google Summer of Code: question about GiST API advancement project
Следующее
От: Darafei "Komяpa" Praliaskouski
Дата:
Сообщение: Re: Berserk Autovacuum (let's save next Mandrill)