Skip site navigation (1) Skip section navigation (2)

Schema Limitations ?

From: Chris Broussard <cbroussard(at)liquiddatainc(dot)com>
To: pgsql-hackers(at)postgresql(dot)org
Subject: Schema Limitations ?
Date: 2006-05-28 04:13:58
Message-ID: AB2498E7-CBF2-4042-8F9B-7D26E5B862AE@liquiddatainc.com (view raw or flat)
Thread:
Lists: pgsql-generalpgsql-hackers
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 ?

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

Responses

pgsql-hackers by date

Next:From: Tom LaneDate: 2006-05-28 05:00:18
Subject: Re: [HACKERS] psql \copy warning
Previous:From: Alvaro HerreraDate: 2006-05-28 03:32:53
Subject: Re: RELKIND_SPECIAL

pgsql-general by date

Next:From: Gurjeet SinghDate: 2006-05-28 04:53:05
Subject: no prompt in psql!!!
Previous:From: Chris BrowneDate: 2006-05-27 22:44:13
Subject: Re: Invoke diff from plpgsql?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group