Search Postgresql Archives

Re: max_fsm_relations

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Bill Moran <wmoran@xxxxxxxxxxxxxxxxx> writes:
> In response to "Gauthier, Dave" <dave.gauthier@xxxxxxxxx>:
>> There is no way I have 1000 tables/indexes.  But maybe it's counting table/index file extensions in the mix?  What's the metadata 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

-- 
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux