"Lee Wu" <Lwu(at)mxlogic(dot)com> writes:
> 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."=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 Wu||Date: 2004-06-18 22:51:27|
|Subject: bad data with Foreign Key constraint|
|Previous:||From: Lee Wu||Date: 2004-06-18 20:08:02|
|Subject: table when vacuum questions|