Home > mailing lists

table when vacuum questions - Mailing list pgsql-admin

From	Lee Wu
Subject	table when vacuum questions
Date	June 18, 2004 20:08:18
Msg-id	ECAB83AA52BCC043A0E24BBC00001024111263@mxhq-exch.corp.mxlogic.com Whole thread Raw
Responses	Re: table when vacuum questions
List	pgsql-admin

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,

From: Tom Lane
Date: 18 June 2004, 18:34:42
Subject: Re: pg_restore patch

From: Tom Lane
Date: 18 June 2004, 22:26:30
Subject: Re: table when vacuum questions