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