Question on vacuum output

From: "Chris Hoover" <revoohc(at)gmail(dot)com>
To: "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>
Subject: Question on vacuum output
Date: 2006-06-20 20:49:25
Message-ID: 1d219a6f0606201349w48f2cfd0s68914352c76cb4a0@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

I am having some performance issues on some of my larger databases
(50-100+GB). I just ran a vacuum analyze on our key table, and saw this at
the end.

DETAIL: 562499 dead row versions cannot be removed yet.
There were 15117 unused item pointers.
0 pages are entirely empty.
CPU 8.32s/2.59u sec elapsed 340.19 sec.
INFO: analyzing "public.clmhdr"
INFO: "clmhdr": scanned 30000 of 221695 pages, containing 259684 live rows
and 75400 dead rows; 30000 rows in sample, 1919021 estimated total rows
VACUUM

What does this mean that there are 562499 dead row versions that could not
be removed? Could this be part of the performance issue? I have a query
that before the vacuum was running in 1-2 seconds and normally after a
vacuum analyze will run in a couple hundred miliseconds. (Although this run
of the vacuum analyze does not appear to have helped much, my tell tale
query is still running 1sec+).

Thanks,

Chris

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Alvaro Herrera 2006-06-20 21:08:28 Re: Question on vacuum output
Previous Message Bruno Wolff III 2006-06-20 20:37:57 Re: Unique constraint and index-combination feature in 8.1