Postgres Pro
Downloads
Home   >   mailing lists

Re: Is autovacuum too noisy about orphan temp tables? - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Is autovacuum too noisy about orphan temp tables?
Date
Msg-id 15553.1224018098@sss.pgh.pa.us
Whole thread Raw
In response to Re: Is autovacuum too noisy about orphan temp tables?  (ITAGAKI Takahiro <itagaki.takahiro@oss.ntt.co.jp>)
Responses Re: Is autovacuum too noisy about orphan temp tables?
List pgsql-hackers
Tree view 
ITAGAKI Takahiro <itagaki.takahiro@oss.ntt.co.jp> writes:
> Why can't we drop orphan temp tables automatically?

See prior discussion --- it was deemed too risky.  What if there's a bug
in the determination of what's an orphan temp table?

> Standard DBAs are blind to LOG level messages.

Indeed, which is why I'm not too concerned about Heikki's complaint.
        regards, tom lane

pgsql-hackers by date:

Previous
From: Stefan Kaltenbrunner
Date:
Subject: Re: spoonbill is failing citext test
Next
From: Alvaro Herrera
Date:
Subject: Re: Is autovacuum too noisy about orphan temp tables?