Re: [HACKERS] DROP TABLE and autovacuum

2007-06-20 Thread ITAGAKI Takahiro
Alvaro Herrera [EMAIL PROTECTED] wrote: 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. We don't invalidate the value statistics in

Re: [HACKERS] DROP TABLE and autovacuum

2007-06-14 Thread ITAGAKI Takahiro
Alvaro Herrera [EMAIL PROTECTED] wrote: ITAGAKI Takahiro wrote: autovacuum killer triggered in CREATE/DROP/RENAME DATABASE commands. Can we extend the feature to several TABLE commands? Well, one problem with this is that currently SIGINT cancels the whole autovacuum worker, not just the

Re: [HACKERS] DROP TABLE and autovacuum

2007-06-14 Thread Alvaro Herrera
ITAGAKI Takahiro wrote: Alvaro Herrera [EMAIL PROTECTED] wrote: ITAGAKI Takahiro wrote: autovacuum killer triggered in CREATE/DROP/RENAME DATABASE commands. Can we extend the feature to several TABLE commands? Well, one problem with this is that currently SIGINT cancels the whole

Re: [HACKERS] DROP TABLE and autovacuum

2007-06-14 Thread Alvaro Herrera
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

[HACKERS] DROP TABLE and autovacuum

2007-06-13 Thread ITAGAKI Takahiro
If we tries to drop the table on which autovacuum is running, we have to wait finish of the vacuum. However, the vacuuming effort goes to waste for the table being dropped or rewritten. Meanwhile, we've already had the autovacuum killer triggered in CREATE/DROP/RENAME DATABASE commands. Can we

Re: [HACKERS] DROP TABLE and autovacuum

2007-06-13 Thread Alvaro Herrera
ITAGAKI Takahiro wrote: If we tries to drop the table on which autovacuum is running, we have to wait finish of the vacuum. However, the vacuuming effort goes to waste for the table being dropped or rewritten. Meanwhile, we've already had the autovacuum killer triggered in CREATE/DROP/RENAME

Re: [HACKERS] DROP TABLE and autovacuum

2007-06-13 Thread Tom Lane
ITAGAKI Takahiro [EMAIL PROTECTED] writes: If we tries to drop the table on which autovacuum is running, we have to wait finish of the vacuum. However, the vacuuming effort goes to waste for the table being dropped or rewritten. Meanwhile, we've already had the autovacuum killer triggered in