table when vacuum questions

From: "Lee Wu" <Lwu(at)mxlogic(dot)com>
To: <pgsql-admin(at)postgresql(dot)org>
Subject: table when vacuum questions
Date: 2004-06-18 20:08:02
Message-ID: ECAB83AA52BCC043A0E24BBC00001024111263@mxhq-exch.corp.mxlogic.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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,

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Tom Lane 2004-06-18 22:26:09 Re: table when vacuum questions
Previous Message Tom Lane 2004-06-18 18:28:50 Re: pg_restore patch