Re: Vacuuming leaked temp tables (once again)

Поиск
Список
Период
Сортировка
От Gregory Stark
Тема Re: Vacuuming leaked temp tables (once again)
Дата
Msg-id 87d4m2rh5n.fsf@oxford.xeocode.com
обсуждение исходный текст
Ответ на Vacuuming leaked temp tables (once again)  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: Vacuuming leaked temp tables (once again)
Список pgsql-hackers
"Tom Lane" <tgl@sss.pgh.pa.us> writes:

> The main attractions of this idea are avoiding the corrupt-index issue and
> not doing vacuuming work that's 99.99% sure to be useless.

It does seem strange to me to vacuum a table you're pretty sure is useless
*and* quite likely corrupt.

Could autovacuum emit log messages as soon as it sees such tables and start
dropping them at some point later?

--  Gregory Stark EnterpriseDB          http://www.enterprisedb.com Ask me about EnterpriseDB's RemoteDBA services!


В списке pgsql-hackers по дате отправления:

Предыдущее
От: "Heikki Linnakangas"
Дата:
Сообщение: Re: [PATCHES] Hint Bits and Write I/O
Следующее
От: Florian Pflug
Дата:
Сообщение: Re: Planner creating ineffective plans on LEFT OUTER joins