pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Question on vacuum output
2+ messages / 2 participants
[nested] [flat]

* Question on vacuum output
@ 2006-06-20 20:49  Chris Hoover <revoohc@gmail.com>
  0 siblings, 1 reply; 2+ messages in thread

From: Chris Hoover @ 2006-06-20 20:49 UTC (permalink / raw)
  To: 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

^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* Re: Question on vacuum output
@ 2006-06-20 21:08  Alvaro Herrera <alvherre@commandprompt.com>
  parent: Chris Hoover <revoohc@gmail.com>
  0 siblings, 0 replies; 2+ messages in thread

From: Alvaro Herrera @ 2006-06-20 21:08 UTC (permalink / raw)
  To: Chris Hoover <revoohc@gmail.com>; +Cc: pgsql-admin

Chris Hoover wrote:
> 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.

Is there an open, idle transaction on this database?  A leftover psql
session running in a forgotten, detached screen session maybe?

-- 
Alvaro Herrera                                http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support



^ permalink  raw  reply  [nested|flat] 2+ messages in thread


end of thread, other threads:[~2006-06-20 21:08 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2006-06-20 20:49 Question on vacuum output Chris Hoover <revoohc@gmail.com>
2006-06-20 21:08 ` Alvaro Herrera <alvherre@commandprompt.com>

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