Gourish Singbal wrote: > The Age of the database is 1144759836 . We have enabled autovacuuming . > The details are:- > autovacuum = on Are you sure autovacuum is enabled? Do a "SHOW autovacuum" just to be sure. The test for database-wide vacuum is: database age > big_constant where: big_constant = (MaxTransactionId >> 3) * 3 - 100000) = 1610512733 MaxTransactionId = 0xFFFFFFFF database age = Max(frozen age, vacuum age) frozen age = next Transaction id - pg_database.datfrozenxid vacuum age = next Transaction id - pg_database.datvacuumxid Your database is still 465752897 transactions away from that apparently. -- Alvaro Herrera http://www.CommandPrompt.com/ The PostgreSQL Company - Command Prompt, Inc.
