Skip site navigation (1) Skip section navigation (2)

Re: pgsql: Prevent CLUSTER from decreasing a relation's relfrozenxid.

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Alvaro Herrera <alvherre(at)commandprompt(dot)com>
Cc: pgsql-committers(at)postgresql(dot)org
Subject: Re: pgsql: Prevent CLUSTER from decreasing a relation's relfrozenxid.
Date: 2008-01-15 23:40:18
Message-ID: 14964.1200440418@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-committers
Alvaro Herrera <alvherre(at)commandprompt(dot)com> writes:
> I don't think it explains the reported bug, though; this is all new in
> 8.3.

No, it certainly doesn't explain the problem JD reported --- not only is
it new code in 8.3, but the symptom is backwards from what was reported
(main table's relfrozenxid older than toast table's, instead of newer).

It's barely possible that the symptom is actually the same and there was
a wraparound issue in there too, but I suspect that what JD really had
there was some kind of PITR tracking problem.  Can't think what though.
When we first got the report I went trolling for places that might fail
to WAL-log a relfrozenxid update, but I couldn't find anything.

			regards, tom lane

In response to

pgsql-committers by date

Next:From: Teodor SigaevDate: 2008-01-16 13:01:03
Subject: pgsql: Fix core dump with buffer-overrun by too long infinitive.
Previous:From: Alvaro HerreraDate: 2008-01-15 22:31:54
Subject: Re: pgsql: Prevent CLUSTER from decreasing arelation's relfrozenxid.

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group