Re: [bug fix] Suppress "autovacuum: found orphan temp table" message

Поиск
Список
Период
Сортировка
От Andres Freund
Тема Re: [bug fix] Suppress "autovacuum: found orphan temp table" message
Дата
Msg-id 20140722142556.GE4190@alap3.anarazel.de
обсуждение исходный текст
Ответ на Re: [bug fix] Suppress "autovacuum: found orphan temp table" message  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: [bug fix] Suppress "autovacuum: found orphan temp table" message  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
On 2014-07-22 10:17:15 -0400, Tom Lane wrote:
> Or even more to the point, investigate why it's there in the first
> place; perhaps there's an actual fixable bug somewhere in there.

I think MauMau's scenario of a failover to another database explains
their existance - there's no step that'd remove them after promoting a
standby.

So there indeed is a need to have a sensible mechanism for removing them
at some point. But it should be about removing, not ignoring them.

Greetings,

Andres Freund

-- Andres Freund                       http://www.2ndQuadrant.com/PostgreSQL Development, 24x7 Support, Training &
Services



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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: [bug fix] Suppress "autovacuum: found orphan temp table" message
Следующее
От: Tom Lane
Дата:
Сообщение: Re: [bug fix] Suppress "autovacuum: found orphan temp table" message