Skip to content
loading...

re: Basic PostgreSQL tuning parameters VIEW POST

TOP OF THREAD FULL DISCUSSION
re: Hi, how about if in one server there are several PostgreSQL instances. As I have one server with 4 PostgreSQL instances. do you need to divide the...
 

When you run multiple instances of a database engine on one server you are sooner or later running into resource problems as they compete about the same resources.
In an ideal world, you'd have one database server on one server installed and this
the database server is perfectly tuned to use the server's resources.
From this point of view, you should try to bundle multiple databases into one instance.

If this is not an option you need to do more than diving the amount of RAM available.

As this is not a recommended setup I can't give you advice here beside: don't do it.

 

Yes, I thought the same, as in the long run I will have issues related with resources. But for now, I need to work with this situation.

Thanks a lot for the great article and answer

code of conduct - report abuse