[GENERAL] Continual increase of age(datfrozenxid) for template0

2009-02-10 Thread Justin Pasher
Hello, I'm trying to understand if this is normal. This is a Postgres 8.1.15 server (the same one in use when I reported the autovacuum problem here: http://archives.postgresql.org/pgsql-general/2009-01/msg00404.php). Since most of our servers are still stuck on Postgres 7.4, I don't have

Re: [GENERAL] Continual increase of age(datfrozenxid) for template0

2009-02-10 Thread Tom Lane
Justin Pasher just...@newmediagateway.com writes: As you can see, it is starting to approach the 2 billion mark. If I change the datallowconn setting to TRUE, connect to template0, then perform a VACUUM FREEZE, the age(datfrozenxid) goes way down (probably around the 3 million mark).