reasonable limit to number of schemas in a database?

From: Ben <bench(at)silentmedia(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: reasonable limit to number of schemas in a database?
Date: 2007-04-24 20:40:35
Message-ID: Pine.LNX.4.64.0704241336450.27105@localhost.localdomain
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I'm considering re-architecting a database to make use of many, many
schemas.... over time, it would probably grow to be on the order of 3,000
or so, with each schema holding ~100 tables. Is that an absurd amount, or
well within postgres' limits? I haven't been able to find any information
on what penalties one pays as you increase the schema count.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Angva 2007-04-24 20:44:52 ERROR: variable not found in subplan target lists
Previous Message Peter Eisentraut 2007-04-24 20:08:42 Re: conditional joins and views