Re: Vacuuming leaked temp tables (once again)
Tom Lane <tgl@sss.pgh.pa.us>
From: Tom Lane <tgl@sss.pgh.pa.us>
To: "Matthew T. O'Connor" <matthew@zeut.net>
Cc: Gregory Stark <stark@enterprisedb.com>, pgsql-hackers@postgreSQL.org
Date: 2008-06-28T02:34:26Z
Lists: 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