On Tue, Aug 18, 2009 at 2:41 PM, Kevin Kempter<kevink@xxxxxxxxxxxxxxxxxxx> wrote: > 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? Nope, just an open transaction of any kind. -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
