Bryan Murphy <bmurphy1976(at)gmail(dot)com> writes:
> On Mon, Aug 17, 2009 at 12:17 PM, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
>> Hm, what's your current XID counter? (pg_controldata would give an
>> approximate answer.) I'm wondering if the xmax's are marked committed
>> but are in the future ...
> Latest checkpoint's NextXID: 0/308829887
Hmm, well, they're in the past *now*, but by less than 20000
transactions. You said this was a production DB so that might not
represent very much elapsed time. Does the DELETE still fail?
regards, tom lane