am Wed, dem 25.04.2007, um 1:14:15 -0400 mailte Tom Lane folgendes: > Ben <bench@xxxxxxxxxxxxxxx> 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
