[HACKERS] A note about VACUUM syntax

2008-06-15 Thread Tom Lane
I was thinking about the proposals that have been made a couple of times to offer a variant of VACUUM that works by table-rewriting (ie, same as CLUSTER except for not sorting the rows). I thought I'd do some experimentation to see what a reasonable syntax for it would be. I soon convinced

Re: [HACKERS] A note about VACUUM syntax

2008-06-15 Thread Peter Eisentraut
Tom Lane wrote: maybe it is time to bite the bullet and clean up VACUUM's syntax so that new modifiers can be added without making them reserved words.  The first idea that comes to mind is something like VACUUM [tablename] [ WITH REPLACE, VERBOSE [, ...] ] I'd be OK with putting

Re: [HACKERS] A note about VACUUM syntax

2008-06-15 Thread Tom Lane
Peter Eisentraut [EMAIL PROTECTED] writes: Tom Lane wrote: maybe it is time to bite the bullet and clean up VACUUM's syntax so that new modifiers can be added without making them reserved words.  The first idea that comes to mind is something like I'd be OK with putting the options at the