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
---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@xxxxxxxxxxxxxx so that your
message can get through to the mailing list cleanly
