]> granicus.if.org Git - postgresql/commit
Allow multiple tables to be specified in one VACUUM or ANALYZE command.
authorTom Lane <tgl@sss.pgh.pa.us>
Tue, 3 Oct 2017 22:53:44 +0000 (18:53 -0400)
committerTom Lane <tgl@sss.pgh.pa.us>
Tue, 3 Oct 2017 22:53:44 +0000 (18:53 -0400)
commit11d8d72c27a64ea4e30adce11cf6c4f3dd3e60db
treeedfc217d80302fb5f5a6a36f8de4312e832b634b
parent45f9d08684d954b0e514b69f270e763d2785dd53
Allow multiple tables to be specified in one VACUUM or ANALYZE command.

Not much to say about this; does what it says on the tin.

However, formerly, if there was a column list then the ANALYZE action was
implied; now it must be specified, or you get an error.  This is because
it would otherwise be a bit unclear what the user meant if some tables
have column lists and some don't.

Nathan Bossart, reviewed by Michael Paquier and Masahiko Sawada, with some
editorialization by me

Discussion: https://postgr.es/m/E061A8E3-5E3D-494D-94F0-E8A9B312BBFC@amazon.com
14 files changed:
doc/src/sgml/ref/analyze.sgml
doc/src/sgml/ref/vacuum.sgml
src/backend/commands/vacuum.c
src/backend/nodes/copyfuncs.c
src/backend/nodes/equalfuncs.c
src/backend/nodes/makefuncs.c
src/backend/parser/gram.y
src/backend/postmaster/autovacuum.c
src/include/commands/vacuum.h
src/include/nodes/makefuncs.h
src/include/nodes/nodes.h
src/include/nodes/parsenodes.h
src/test/regress/expected/vacuum.out
src/test/regress/sql/vacuum.sql