Re: reasonable limit to number of schemas in a database?

am Wed, dem 25.04.2007, um 1:14:15 -0400 mailte Tom Lane folgendes:
> Ben <bench(at)silentmedia(dot)com> writes:
> > 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.
>
> The number of schemas doesn't scare me so much as the number of tables.
> Are you using a filesystem that can cope gracefully with 300K files in
> one directory? How many of these tables do you anticipate any one

http://people.planetpostgresql.org/greg/index.php?/archives/37-The-million-table-challenge.html

;-)

Andreas
--
Andreas Kretschmer
Kontakt: Heynitz: 035242/47150, D1: 0160/7141639 (mehr: -> Header)
GnuPG-ID: 0x3FFF606C, privat 0x7F4584DA http://wwwkeys.de.pgp.net