On Fri, Apr 5, 2019 at 3:28 PM Robert Haas <robertmh...@gmail.com> wrote: > > 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. >
+1 for this syntax. cheers andrew -- Andrew Dunstan https://www.2ndQuadrant.com PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services
