pg.ddx.io pgsql-admin@postgresql.org mailing list archivehelp / color / mirror / Atom feed
table when vacuum questions 3+ messages / 2 participants [nested] [flat]
* table when vacuum questions @ 2004-06-18 20:08 Lee Wu <Lwu@mxlogic.com> 2004-06-18 22:26 ` Re: table when vacuum questions Tom Lane <tgl@sss.pgh.pa.us> 0 siblings, 1 reply; 3+ messages in thread From: Lee Wu @ 2004-06-18 20:08 UTC (permalink / raw) To: 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, ^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: table when vacuum questions 2004-06-18 20:08 table when vacuum questions Lee Wu <Lwu@mxlogic.com> @ 2004-06-18 22:26 ` Tom Lane <tgl@sss.pgh.pa.us> 0 siblings, 0 replies; 3+ messages in thread From: Tom Lane @ 2004-06-18 22:26 UTC (permalink / raw) To: Lee Wu <Lwu@mxlogic.com>; +Cc: pgsql-admin "Lee Wu" <Lwu@mxlogic.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 ^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: table when vacuum questions @ 2004-06-18 22:55 Lee Wu <Lwu@mxlogic.com> 0 siblings, 0 replies; 3+ messages in thread From: Lee Wu @ 2004-06-18 22:55 UTC (permalink / raw) To: Tom Lane <tgl@sss.pgh.pa.us>; +Cc: pgsql-admin Thanks Tom for your quick response... -----Original Message----- From: Tom Lane [mailto:tgl@sss.pgh.pa.us] Sent: Friday, June 18, 2004 3:26 PM To: Lee Wu Cc: pgsql-admin@postgresql.org Subject: Re: [ADMIN] table when vacuum questions "Lee Wu" <Lwu@mxlogic.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 ^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2004-06-18 22:55 UTC | newest] Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2004-06-18 20:08 table when vacuum questions Lee Wu <Lwu@mxlogic.com> 2004-06-18 22:26 ` Tom Lane <tgl@sss.pgh.pa.us> 2004-06-18 22:55 Re: table when vacuum questions Lee Wu <Lwu@mxlogic.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions for how to clone and mirror all data and code used for this inbox