Re: table when vacuum questions

Thanks Tom for your quick response...

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

"Lee Wu" <Lwu(at)mxlogic(dot)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