In response to Dan Harris <fbsd@xxxxxxxxxxxxxxx>: > > > kah_hang_ang@xxxxxxxxxxxx wrote: > > > >> both of the two database are live but use for two different web app. > >> my company don't want to spend more to buy a new server, so then I think of > >> to implement both under the same server and one instance.. > > Just as an anecdote, I am running 30 databases on a single instance and > it's working quite well. There may be reasons to run multiple > instances but it seems like tuning them to cooperate for memory would > pose some problems - e.g. effective_cache_size. The only reason I can see for doing this is when you need to run two different versions of PostgreSQL. Which is what I've been forced to do on one of our servers. It works, but it's a pain to admin. If you can just put all the databases in one db cluster (is that terminology still correct?) it'll be much easier. -- Bill Moran Collaborative Fusion Inc.
