From: Chris Hoover <revoohc@gmail.com>
To: pgsql-admin@postgresql.org <pgsql-admin@postgresql.org>
Subject: Question on vacuum output
Date: Tue, 20 Jun 2006 16:49:25 -0400
Message-ID: <1d219a6f0606201349w48f2cfd0s68914352c76cb4a0@mail.gmail.com> (raw)
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-admin@postgresql.org
Cc: revoohc@gmail.com
Subject: Re: Question on vacuum output
In-Reply-To: <1d219a6f0606201349w48f2cfd0s68914352c76cb4a0@mail.gmail.com>
References: <1d219a6f0606201349w48f2cfd0s68914352c76cb4a0@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox