Heikki Linnakangas <heikki.linnakangas@enterprisedb.com> wrote:
> I got the impression that replacing VACUUM FULL is the most popular
> opinion. I like VACUUM REWRITE myself, except that it would require
> making REWRITE a reserved keyword.
My next proposal for the syntex is "VACUUM (options) table_name".
Since "options" are quoted by '(' and ')', we can add new options
without adding them into reserved keywords.
The traditional vacuum syntax: VACUUM FULL FREEZE VERBOSE ANALYZE table_name (columns);
will be: VACUUM (FULL, FREEZE, VERBOSE, ANALYZE) table_name (columns);
I think the syntax is consistent with existing syntex of "EXPLAIN (...)".
We can choose any keyword for the new "rewrite" version.
For example: * VACUUM ( REWRITE ) * VACUUM ( FULL [ INPLACE | REPLACE ] )
Regards,
---
ITAGAKI Takahiro
NTT Open Source Software Center