On Sat, Aug 09, 2003 at 05:45:59PM -0300, Claudio Lapidus wrote: > > Run VACUUM VERBOSE on it; you'll no doubt see that some internal > > tables such as pg_activity, pg_statistic, and such have a lot of dead > > tuples. Establishing a connection leads to _some_ DB activity, and > > probably a dead tuple or two; every time you ANALYZE, you create a > > bunch of dead tuples since old statistics are "killed off." > > What? Does this mean that it is needed to routinely vacuum system tables > too? If so, which is the recommended procedure?
On our system we do a vacuum analyze every night to cleanup what happened during the day. Vacuum without a table name does all tables so you don't explicitly need to list them. -- Martijn van Oosterhout <[EMAIL PROTECTED]> http://svana.org/kleptog/ > "All that is needed for the forces of evil to triumph is for enough good > men to do nothing." - Edmond Burke > "The penalty good people pay for not being interested in politics is to be > governed by people worse than themselves." - Plato
pgp00000.pgp
Description: PGP signature
