Moving to -general, where this belongs. On Sat, May 27, 2006 at 11:13:58PM -0500, Chris Broussard wrote: > Hello Hackers, > > I have the following questions, after reading this FAQ (http:// > www.postgresql.org/docs/faqs.FAQ.html#item4.4) are there statistics > around the max number of schemas in a database, max number of tables > In a schema, and max number of tables in a database (number that > spans schemas) ? Are the only limitations based on disk & ram/swap ? One hard limit you'll run into is OIDs, which max at either 2^31 or 2^32 (I can't remember offhand which it is). That would be number of schemas, and number of total tables (there's a unique index on pg_class.oid). Actually, you'll be limited to 2 or 4 billion tables, indexes, and views. In reality, I suspect you'll become very unhappy with performance well before those numbers. Running a database with just 10000 tables can be a bit tricky, though it's certainly doable. > Does anybody have a rough ballpark figures of the largest install > base on those questions? > > I'm curious about these stats, because I'm debating on how best to > break up data, between schemas, physical separate databases, and the > combination of the two. > > Thanks In Advanced. > > Chris > > ---------------------------(end of broadcast)--------------------------- > TIP 2: Don't 'kill -9' the postmaster > -- Jim C. Nasby, Sr. Engineering Consultant jnasby@xxxxxxxxxxxxx Pervasive Software http://pervasive.com work: 512-231-6117 vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461
