Postgres Pro
Downloads
Home   >   mailing lists

Re: reloption to prevent VACUUM from truncating empty pages at the end of relation - Mailing list pgsql-hackers

From Darafei Praliaskouski
Subject Re: reloption to prevent VACUUM from truncating empty pages at the end of relation
Date
Msg-id 155453718772.16480.8982498117656778884.pgcf@coridan.postgresql.org
Whole thread Raw
In response to Re: Re: reloption to prevent VACUUM from truncating empty pages atthe end of relation  (Robert Haas <robertmhaas@gmail.com>)
List pgsql-hackers
Tree view 
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 by date:

Previous
From: GUO Rui
Date:
Subject: Re: Google Summer of Code: question about GiST API advancement project
Next
From: Darafei "Komяpa" Praliaskouski
Date:
Subject: Re: Berserk Autovacuum (let's save next Mandrill)