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 ---------------------------(end of broadcast)--------------------------- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
