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

On Nov 19, 2005, at 12:24 , anon permutation wrote:

> 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?

I'm sure those wiser than me will chime in with specifics. I think
you should be think of usage not in terms of number of databases but
in terms of connections rates, database size (numbers of tables and
tuples) and the types of queries that will be run. While there may be
a little overhead in from having a number of databases in the
cluster, I think this is probably going to be insignificant in
comparison to these other factors. A better idea of what the usage
will guide you in choosing your hardware.


Michael Glaesemann
grzm myrealbox com