table when vacuum questions

[Lee Wu]

Hi,



I have two questions regarding the PG doc:



1.
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?

2. 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,

[Tom Lane]

Post by Lee Wu
http://www.postgresql.org/docs/7.3/static/routine-vacuuming.html#VACUUM-
"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.

Post by Lee Wu
"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

[Lee Wu]

Thanks Tom for your quick response...


-----Original Message-----
From: Tom Lane [mailto:***@sss.pgh.pa.us]
Sent: Friday, June 18, 2004 3:26 PM
To: Lee Wu
Cc: pgsql-***@postgresql.org
Subject: Re: [ADMIN] table when vacuum questions

"Lee Wu" <***@mxlogic.com> writes:
http://www.postgresql.org/docs/7.3/static/routine-vacuuming.html#VACUUM-

Post by Lee Wu
"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.

Post by Lee Wu
"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 ***@postgresql.org so that your
message can get through to the mailing list cleanly