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

From: "anon permutation" <anonpermutation(at)hotmail(dot)com>
To: pgsql-performance(at)postgresql(dot)org
Subject: What is the max number of database I can create in an instance of pgsql?
Date: 2005-11-19 03:24:08
Message-ID: BAY106-F29AAEBFDCAA6E044ECFAC6B7510@phx.gbl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance


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,
what is the max number of database I can create before performance goes
down?

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.

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Michael Glaesemann 2005-11-19 03:49:43 Re: What is the max number of database I can create in an instance of pgsql?
Previous Message Mark Kirkwood 2005-11-19 02:27:49 Re: Hardware/OS recommendations for large databases (