Bryan Murphy <bmurphy1...@gmail.com> writes: > On Mon, Aug 17, 2009 at 12:17 PM, Tom Lane <t...@sss.pgh.pa.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 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general