| From: | Bruce Momjian <bruce(at)momjian(dot)us> |
|---|---|
| To: | Anand Muthukrishnan <lucky(dot)developer(at)gmail(dot)com> |
| Cc: | "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org> |
| Subject: | Re: Postgres schema having > 20,000 schemas |
| Date: | 2013-07-24 18:17:23 |
| Message-ID: | 20130724181723.GE31462@momjian.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
On Wed, Jul 24, 2013 at 11:38:05PM +0530, Anand Muthukrishnan wrote:
> We want them all in one Database.
>
> Multi database architecture is giving high amount of overhead during database migrations and database connection pooling. So we are evaluating single db with multi schema approach.
>
> Also, is there any hard limit on number of schemas and tables that can be present in one postgres database?
Not really, unless you start getting into the 100M count.
--
Bruce Momjian <bruce(at)momjian(dot)us> http://momjian.us
EnterpriseDB http://enterprisedb.com
+ It's impossible for everything to be true. +
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Luis | 2013-07-26 15:31:06 | Question about DB stats resets |
| Previous Message | Anand Muthukrishnan | 2013-07-24 18:08:05 | Re: Postgres schema having > 20,000 schemas |