Hello Team,
We are planning to create multiple clusters on a single server (single
instance) with PostgreSQL V.10 to run multiple applications.
I don't know if it is a good idea to use a single machine to run n clusters
but we are looking to minimize the cost of servers and other resources.
Please share your thoughts on this approach?
How can we create multiple clusters under a single postgres version?
How can we identify/allocate the resources to parameters like
shared_buffers, effective_cache_size, work_mem etc in case of multiple
clusters?
Thanks