Re: vacuum all but system tables - Mailing list pgsql-sql

From Tom Lane
Subject Re: vacuum all but system tables
Date
Msg-id 6728.1048085238@sss.pgh.pa.us
Whole thread Raw
In response to Re: vacuum all but system tables  ("Victor Yegorov" <viy@pirmabanka.lv>)
List pgsql-sql
"Victor Yegorov" <viy@pirmabanka.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


pgsql-sql by date:

Previous
From: "Victor Yegorov"
Date:
Subject: Re: vacuum all but system tables
Next
From: Tomasz Myrta
Date:
Subject: Re: vacuum all but system tables