From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
---|---|
To: | Menelaos PerdikeasSemantix <mperdikeas(dot)semantix(at)gmail(dot)com> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: maximum number of databases and / or schemas in a single database instance |
Date: | 2012-08-05 04:05:20 |
Message-ID: | 3768.1344139520@sss.pgh.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Menelaos PerdikeasSemantix <mperdikeas(dot)semantix(at)gmail(dot)com> writes:
> The following page:
> http://www.postgresql.org/about/
> mentions some limits but not the following:
> [1] maximum number of databases per database server instance
> [2] maximum number of schemas per database
> Is there empirical information on whether both these values can be as high
> as a few hundreds? (I don't really need any more for my use case)
You can certainly have hundreds of schemas. I wouldn't really recommend
more than a few dozen databases per instance, though. It tends to bog
down autovacuum, and remember you are storing a separate copy of the
system catalogs per database. You might be able to make a few hundred
databases work all right if you don't mind expending some tuning effort;
but a few thousand is probably right out.
regards, tom lane
From | Date | Subject | |
---|---|---|---|
Next Message | Chris Angelico | 2012-08-05 04:34:55 | Re: maximum number of databases and / or schemas in a single database instance |
Previous Message | Mary F. Masterson | 2012-08-04 20:56:30 | Pgadmin3 v1.14.2 foreign keys |