Bryan Murphy <bmurphy1976@xxxxxxxxx> writes: > On Mon, Aug 17, 2009 at 12:17 PM, Tom Lane <tgl@xxxxxxxxxxxxx> 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@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
