Thread: table when vacuum questions
Hi,
I have two questions regarding the PG doc:
- 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?
- http://www.postgresql.org/docs/7.3/static/sql-vacuum.html says: “Defaults to all tables in the current database.”
Does “all tables include PG’s tables, such as pg_class?
Thanks,
"Lee Wu" <Lwu@mxlogic.com> 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
Thanks Tom for your quick response... -----Original Message----- From: Tom Lane [mailto:tgl@sss.pgh.pa.us] Sent: Friday, June 18, 2004 3:26 PM To: Lee Wu Cc: pgsql-admin@postgresql.org Subject: Re: [ADMIN] table when vacuum questions "Lee Wu" <Lwu@mxlogic.com> 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