Re: max_fsm_relations

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: max_fsm_relations
Дата
Msg-id 24360.1235771561@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: max_fsm_relations  (Bill Moran <wmoran@potentialtech.com>)
Ответы Re: max_fsm_relations  ("Gauthier, Dave" <dave.gauthier@intel.com>)
Список pgsql-general
Bill Moran <wmoran@potentialtech.com> writes:
> In response to "Gauthier, Dave" <dave.gauthier@intel.com>:
>> There is no way I have 1000 tables/indexes.  But maybe it's counting table/index file extensions in the mix?  What's
themetadata query to see these 1000 relations? 

> Are you counting tables, indexes, sequences, pg_toast tables, system tables?

I think sequences don't count here, but toast tables and system catalogs
surely do.  Also, as you said, it's the total across all databases in
the installation that counts.

            regards, tom lane

В списке pgsql-general по дате отправления:

Предыдущее
От: Greg Smith
Дата:
Сообщение: Re: max_fsm_relations
Следующее
От: "Gauthier, Dave"
Дата:
Сообщение: Re: max_fsm_relations