On Tuesday 18 August 2009 13:37:12 Tom Lane wrote: > Kevin Kempter <kevink@xxxxxxxxxxxxxxxxxxx> writes: > > INFO: "action_rollup_notifier": found 0 removable, 34391214 nonremovable > > row versions in 152175 pages > > DETAIL: 22424476 dead row versions cannot be removed yet. > > > > Anyone have any suggestions per why these rows cannot be removed yet? > > You've got an open transaction that's older than the one that deleted > those rows (or at least started before the latter committed). > pg_stat_activity might be helpful in fingering the culprit. > > regards, tom lane Does the use of serialized transactions affect this in any way? -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
