Postgres Pro
Downloads
Home   >   mailing lists

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

From Adrien Mobile
Subject Re: Re: reloption to prevent VACUUM from truncating empty pages at the end of relation
Date
Msg-id 8919F170-09CD-4F35-B572-E4C70D58DA10@anayrat.info
Whole thread Raw
In response to Re: Re: reloption to prevent VACUUM from truncating empty pages atthe end of relation  (Julien Rouhaud <rjuju123@gmail.com>)
Responses Re: Re: reloption to prevent VACUUM from truncating empty pages atthe end of relation
List pgsql-hackers
Tree view 
Le 5 avril 2019 20:11:38 GMT+02:00, Julien Rouhaud <rjuju123@gmail.com> a écrit :
>On Fri, Apr 5, 2019 at 7:04 PM Robert Haas <robertmhaas@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.

How about TRIM?


--
Sent from my Android phone with K-9 Mail. Please excuse my brevity.

pgsql-hackers by date:

Previous
From: Robert Haas
Date:
Subject: Re: Re: reloption to prevent VACUUM from truncating empty pages atthe end of relation
Next
From: Robert Haas
Date:
Subject: Re: Re: reloption to prevent VACUUM from truncating empty pages atthe end of relation