Hi At least this is documented behavior: > When the option list is surrounded by parentheses, the options can be written > in any order. Without parentheses, options must be specified in exactly the > order shown above. https://www.postgresql.org/docs/current/static/sql-vacuum.html
Previously we have another additional synopsis > VACUUM [ FULL ] [ FREEZE ] [ VERBOSE ] ANALYZE [ table_name [ (column_name [, > ...] ) ] ] Seems this syntax was removed in this commit: https://www.postgresql.org/message-id/E1dzW4X-00089L-5a%40gemulon.postgresql.org regards, Sergei