Skip site navigation (1) Skip section navigation (2)

Re: vacuum question

From: Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>
To: Kevin Kempter <kevink(at)consistentstate(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: vacuum question
Date: 2009-08-18 20:47:14
Message-ID: dcc563d10908181347m4e284e05y7c45cecc8083e13d@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-admin
On Tue, Aug 18, 2009 at 2:41 PM, Kevin
Kempter<kevink(at)consistentstate(dot)com> wrote:
> 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?

Nope, just an open transaction of any kind.

In response to

pgsql-admin by date

Next:From: Kevin KempterDate: 2009-08-18 21:50:02
Subject: vacuum full questions
Previous:From: Kevin KempterDate: 2009-08-18 20:41:47
Subject: Re: vacuum question

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group