Skip site navigation (1) Skip section navigation (2)

Re: table when vacuum questions

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Lee Wu" <Lwu(at)mxlogic(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: table when vacuum questions
Date: 2004-06-18 22:26:09
Message-ID: 4046.1087597569@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-admin
"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

In response to

pgsql-admin by date

Next:From: Lee WuDate: 2004-06-18 22:51:27
Subject: bad data with Foreign Key constraint
Previous:From: Lee WuDate: 2004-06-18 20:08:02
Subject: table when vacuum questions

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group