Re: vacuum all but system tables

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Victor Yegorov" <viy(at)pirmabanka(dot)lv>
Cc: "Postgres SQL" <pgsql-sql(at)postgresql(dot)org>
Subject: Re: vacuum all but system tables
Date: 2003-03-19 14:47:18
Message-ID: 6728.1048085238@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

"Victor Yegorov" <viy(at)pirmabanka(dot)lv> writes:
> May be I'll put my question in a different manner:

> System tables are location-wide (I mean one set of tables for PostgreSQL
> location) or each database has it's own set of system tables?

pg_database, pg_shadow, pg_group are shared, the rest are per-database.

These three are generally not so large that it's worth worrying about
vacuuming them extra times ...

regards, tom lane

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Tomasz Myrta 2003-03-19 14:53:56 Re: vacuum all but system tables
Previous Message Victor Yegorov 2003-03-19 14:39:54 Re: vacuum all but system tables