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
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-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

Browse pgsql-general by date

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

Browse pgsql-hackers by date

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