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