Re: Vacuuming leaked temp tables (once again)

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Vacuuming leaked temp tables (once again)
Дата
Msg-id 16171.1214620466@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Vacuuming leaked temp tables (once again)  ("Matthew T. O'Connor" <matthew@zeut.net>)
Список 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 по дате отправления:

Предыдущее
От: David E. Wheeler
Дата:
Сообщение: PATCH: CITEXT 2.0
Следующее
От: Tom Lane
Дата:
Сообщение: Re: the un-vacuumable table