pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / 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>
  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 22:26  Tom Lane <tgl@sss.pgh.pa.us>
  parent: Lee Wu <Lwu@mxlogic.com>
  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