Re: How many Cluster database on a single server

On 10/19/2011 05:46 PM, d(dot)davolio(at)mastertraining(dot)it wrote:

> My colleagues are asking how many Cluster Databases (initdb) can I
> create and run on a single server. I mean, supposed my server has the
> resources, can I create 100 or even 200 Cluster Databases?

Yep. It won't be fast, but it'll work.

You'll have two performance problems to deal with:

- The memory, CPU and disk I/O overhead of all those extra postmasters,
bgwriters, autovacuum daemons etc running for each cluster; and

- having to split the available shared memory up between each cluster,
so no single cluster gets very much shared memory to use for shared_buffers.

If you keep your shared_buffers low, it should work just fine, but it
won't perform as well as a single PostgreSQL cluster with lots of databases.

In the future I'm hoping someone'll be enthusiastic enough to / need to
add support split WAL logging or partial replication so this sort of
thing isn't necessary. For now it does seem to be the best way to handle
cases where different databases need different replication.

--
Craig Ringer