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

Re: What is the max number of database I can create in an instance of pgsql?

From: Jaime Casanova <systemguards(at)gmail(dot)com>
To: anon permutation <anonpermutation(at)hotmail(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: What is the max number of database I can create in an instance of pgsql?
Date: 2005-11-19 04:55:26
Message-ID: c2d9e70e0511182055y79b1e914ybed284840474b632@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-performance
On 11/18/05, anon permutation <anonpermutation(at)hotmail(dot)com> wrote:
>
> Hi,
>
> We want to create a database for each one of our departments, but we only
> want to have one instance of postgresql running.  There are about 10-20
> departments.  I can easily use createdb to create these databases.  However,
>

After of doing this, you have to think if you will want to make querys
across the info of some or all databases (and you will) if that is the
case the better you can do is create schemas instead of databases...

> what is the max number of database I can create before performance goes
> down?
>

the problem isn't about number of databases but concurrent users...
after all you will have the same resources for 1 or 100 databases, the
important thing is the number of users, the amount of data normal
users will process in a normal day, and complexity of your queries.

> Assuming each database is performing well alone, how would putting 10-20 of
>
> them together in one instance affect postgres?
>
> In terms of getting a new server for this project, how do I gauge how
> powerful of a server should I get?
>
> Thanks.
>
>


--
regards,
Jaime Casanova
(DBA: DataBase Aniquilator ;)

In response to

pgsql-performance by date

Next:From: Alex WangDate: 2005-11-19 07:46:06
Subject: VERY slow after many updates
Previous:From: Michael GlaesemannDate: 2005-11-19 03:49:43
Subject: Re: What is the max number of database I can create in an instance of pgsql?

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