"Lee Wu" <[EMAIL PROTECTED]> writes: > http://www.postgresql.org/docs/7.3/static/routine-vacuuming.html#VACUUM- > FOR-WRAPAROUND says: > "every table in the database must be vacuumed at least once every > billion transactions".
> Does "very table" include PG's tables, such as pg_database? Yes, absolutely. > 2. http://www.postgresql.org/docs/7.3/static/sql-vacuum.html says: > "Defaults to all tables in the current database."=20 > Does "all tables include PG's tables, such as pg_class? Yes, but you have to be superuser; for a non-superuser, the command only vacuums the tables you own. regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
