Postgres Pro
Downloads
Home   >   mailing lists

Re: Question on vacuum output - Mailing list pgsql-admin

From Alvaro Herrera
Subject Re: Question on vacuum output
Date
Msg-id 20060620210828.GH26882@surnet.cl
Whole thread Raw
In response to Question on vacuum output  ("Chris Hoover" <revoohc@gmail.com>)
List pgsql-admin
Tree view 
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

pgsql-admin by date:

Previous
From: "Chris Hoover"
Date:
Subject: Question on vacuum output
Next
From: "Sriram Dandapani"
Date:
Subject: Re: truncate partitioned table locking