Alvaro Herrera wrote: > ITAGAKI Takahiro wrote: > > Hmm, how about canceling only the cases of DROP TABLE, TRUNCATE and CLUSTER. > > We will obviously not need the table after the commands. Other commands, > > VACUUM (FULL), ANALYZE, CREATE INDEX (CONCURRENTLY), REINDEX and LOCK TABLE > > still conflict with autovacuum, but I'll leave it as-is in the meantime. > > Well, all of DROP TABLE, TRUNCATE and CLUSTER seem safe -- and also, > they will advance the table's relfrozenxid. No objection there.
Something worth considering, though unrelated to the topic at hand: what happens with the table stats after CLUSTER? Should we cause an ANALYZE afterwards? We could end up running with outdated statistics. -- Alvaro Herrera http://www.CommandPrompt.com/ PostgreSQL Replication, Consulting, Custom Development, 24x7 support ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster