Re: Bug: Unreferenced temp tables disables vacuum to update xid - Mailing list pgsql-hackers

From Alvaro Herrera
Subject Re: Bug: Unreferenced temp tables disables vacuum to update xid
Date
Msg-id 20080108022821.GD1828@alvh.no-ip.org
Whole thread Raw
In response to Re: Bug: Unreferenced temp tables disables vacuum to update xid  ("Joshua D. Drake" <jd@commandprompt.com>)
List 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 by date:

Previous
From: "Joshua D. Drake"
Date:
Subject: Re: Bug: Unreferenced temp tables disables vacuum to update xid
Next
From: Mark Kirkwood
Date:
Subject: Re: Dynamic Partitioning using Segment Visibility Maps