Postgres Pro
Downloads
Home   >   mailing lists

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

From Robert Haas
Subject Re: Re: reloption to prevent VACUUM from truncating empty pages atthe end of relation
Date
Msg-id CA+TgmoZCAfbv5c38ehTu24zxvWAR3CPvUKHB2_yTrsa8ai8gaw@mail.gmail.com
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  (Andrew Dunstan <andrew.dunstan@2ndquadrant.com>)
List pgsql-hackers
Tree view 
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 by date:

Previous
From: Julien Rouhaud
Date:
Subject: Re: Re: reloption to prevent VACUUM from truncating empty pages atthe end of relation
Next
From: Adrien Mobile
Date:
Subject: Re: Re: reloption to prevent VACUUM from truncating empty pages at the end of relation