On Fri, Apr 5, 2019 at 2:11 PM Julien Rouhaud <rjuju...@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