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
