Re: table when vacuum questions - Mailing list pgsql-admin

From Tom Lane
Subject Re: table when vacuum questions
Date
Msg-id 4046.1087597569@sss.pgh.pa.us
Whole thread Raw
In response to table when vacuum questions  ("Lee Wu" <Lwu@mxlogic.com>)
List pgsql-admin
"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

pgsql-admin by date:

Previous
From: "Lee Wu"
Date:
Subject: table when vacuum questions
Next
From: "Lee Wu"
Date:
Subject: bad data with Foreign Key constraint