Re: Vacuuming leaked temp tables (once again) - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Vacuuming leaked temp tables (once again)
Date
Msg-id 16171.1214620466@sss.pgh.pa.us
Whole thread Raw
In response to Re: Vacuuming leaked temp tables (once again)  ("Matthew T. O'Connor" <matthew@zeut.net>)
List pgsql-hackers
"Matthew T. O'Connor" <matthew@zeut.net> writes:
> Is there an easy way for an Admin clean-up the lost temp tables that 
> autovacuum is complaining about?  It seems like it could be along time 
> and a lot of log messages between when they are first orphaned and and 
> finally dropped due to anti-wraparound protection.

Drop the particular temp schema, maybe?  The log message should probably
make sure to specify the schema name.
        regards, tom lane


pgsql-hackers by date:

Previous
From: David E. Wheeler
Date:
Subject: PATCH: CITEXT 2.0
Next
From: Tom Lane
Date:
Subject: Re: the un-vacuumable table