Search Postgresql Archives

Re: [HACKERS] Schema Limitations ?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux