On Tuesday 18 August 2009 13:37:12 Tom Lane wrote:
> Kevin Kempter <kevink(at)consistentstate(dot)com> 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?