Re: Bug: Unreferenced temp tables disables vacuum to update xid

Поиск
Список
Период
Сортировка
От Alvaro Herrera
Тема Re: Bug: Unreferenced temp tables disables vacuum to update xid
Дата
Msg-id 20080108022821.GD1828@alvh.no-ip.org
обсуждение исходный текст
Ответ на Re: Bug: Unreferenced temp tables disables vacuum to update xid  ("Joshua D. Drake" <jd@commandprompt.com>)
Список pgsql-hackers
Joshua D. Drake wrote:
> Alvaro Herrera wrote:

>> Hmm ... that would be strange.  Off-the-cuff idea: we introduced code to
>> advance relfrozenxid in CLUSTER, TRUNCATE and table-rewriting forms of
>> ALTER TABLE.  Perhaps the problem is that we're neglecting to update it
>> for the toast table there.  AFAIR I analyzed the cases and they were all
>> handled, but perhaps I forgot something.
>
> Just to throw another variable into the mix. This machine was a PITR slave 
> that was pushed into production about two weeks ago.

Ah, right, I bet we have a smoking gun here.

-- 
Alvaro Herrera                                http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support


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

Предыдущее
От: "Joshua D. Drake"
Дата:
Сообщение: Re: Bug: Unreferenced temp tables disables vacuum to update xid
Следующее
От: Mark Kirkwood
Дата:
Сообщение: Re: Dynamic Partitioning using Segment Visibility Maps