Re: max_fsm_relations

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Bill Moran <wmoran(at)potentialtech(dot)com>
Cc: "Gauthier, Dave" <dave(dot)gauthier(at)intel(dot)com>, "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Re: max_fsm_relations
Date: 2009-02-27 21:52:41
Message-ID: 24360.1235771561@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Bill Moran <wmoran(at)potentialtech(dot)com> writes:
> In response to "Gauthier, Dave" <dave(dot)gauthier(at)intel(dot)com>:
>> 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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Gauthier, Dave 2009-02-27 22:04:59 Re: max_fsm_relations
Previous Message Greg Smith 2009-02-27 21:19:20 Re: max_fsm_relations