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 total amount of RAM with how many PG instances first??
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
We're a place where coders share, stay up-to-date and grow their careers.
We strive for transparency and don't collect excess data.