From: | Kevin Kempter <kevink(at)consistentstate(dot)com> |
---|---|
To: | pgsql-admin(at)postgresql(dot)org |
Subject: | vacuum question |
Date: | 2009-08-18 19:19:19 |
Message-ID: | 200908181319.20055.kevink@consistentstate.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
Hi all;
we have a large table that gets a lot of churn throughout the day.
performance has dropped off a cliff. A vacuum verbose on the table showed us
this:
INFO: "action_rollup_notifier": found 0 removable, 34391214 nonremovable row
versions in 152175 pages
DETAIL: 22424476 dead row versions cannot be removed yet.
There were 0 unused item pointers.
2 pages contain useful free space.
0 pages are entirely empty.
CPU 0.03s/2.58u sec elapsed 4.89 sec.
VACUUM
were running at isolation level 1 (autocommit), using serialized transactions
and a persistent db connection.
Anyone have any suggestions per why these rows cannot be removed yet? As far
as we can see these rows should be 'frozen' at this point. Can we force the
issue somehow?
Thanks in advance
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2009-08-18 19:37:12 | Re: vacuum question |
Previous Message | Kenneth Marshall | 2009-08-18 18:02:36 | Re: Warm standby with 8.1 |