Thanks Tom for your quick response...
-----Original Message----- From: Tom Lane [mailto:[EMAIL PROTECTED] Sent: Friday, June 18, 2004 3:26 PM To: Lee Wu Cc: [EMAIL PROTECTED] Subject: Re: [ADMIN] table when vacuum questions "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 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
