Kevin Kempter <kevin@xxxxxxxxxxxxxxxxxxx> writes: > I'm working with a client with several highly active 8.1.4 servers. I want to > run a weekly cron that will vacuum ALL db tables except those with entries in > pg_autovacuum (where we've setup manual/cron vacuums) in order to eliminate > transaction ID wraparound failure warnings (which comes up fairly often). > My question is: > will a select from pg_tables for each database in the cluster provide me with > a full table listing for the purposes of ensuring that all tables in the db > have been vacuumed or are there others I'll need to account for as well ? Why are you insisting on inventing your own wheel for this, when "vacuum" without a parameter does that just fine? regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings
