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
