"Nick Fankhauser" <nickf@xxxxxxxxxx> writes: > On 8/8/07, Tom Lane <tgl@xxxxxxxxxxxxx> wrote: >> Do your vacuums change the pg_database.datfrozenxid values for the >> databases? The only reason I can think of for them not to do so >> is if you're not doing them as superuser ... > They do change the values- I noted this by selecting age(datfrozenxid) > in template1 both before and after vacuuming and noting the change. Uh, that proves very little, because age() is a moving target. Did the raw datfrozenxid column values change? > Our regular vacuum process only runs on our single "prod" database- > not template1. Is template1 a "frozen" database, or just template0? template1 is not frozen in a standard installation. Basically you gotta vacuum everything that has datallowconn = true. regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend
