Re: vacuum all but system tables

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: vacuum all but system tables
Дата
Msg-id 6728.1048085238@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: vacuum all but system tables  ("Victor Yegorov" <viy@pirmabanka.lv>)
Список 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 по дате отправления:

Предыдущее
От: "Victor Yegorov"
Дата:
Сообщение: Re: vacuum all but system tables
Следующее
От: Tomasz Myrta
Дата:
Сообщение: Re: vacuum all but system tables