| 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 |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Lee Wu | 2004-06-18 22:51:27 | bad data with Foreign Key constraint |
| Previous Message | Lee Wu | 2004-06-18 20:08:02 | table when vacuum questions |