| From: | Mladen Gogala <gogala(dot)mladen(at)gmail(dot)com> |
|---|---|
| To: | pgsql-general(at)lists(dot)postgresql(dot)org |
| Subject: | Re: More than one Cluster on single server (single instance) |
| Date: | 2022-07-18 12:04:12 |
| Message-ID: | 52a2a0d6-ce49-afab-bceb-c3cc7f8f8a83@gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On 7/18/22 03:55, Daulat wrote:
> Please share your thoughts on this approach?
>
> How can we create multiple clusters under a single postgres version?
You can use Docker images.
>
> How can we identify/allocate the resources to parameters like
> shared_buffers, effective_cache_size, work_mem etc in case of multiple
> clusters?
>
> Thanks
Each container can be adjusted to have its own memory and parameter
file. Personally, I don't like that approach. I think that separating
data into separate databases is enough separation even for the most
fervent separatists (pun with the name of political movements is purely
accidental).
--
Mladen Gogala
Database Consultant
Tel: (347) 321-1217
https://dbwhisperer.wordpress.com
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Ron | 2022-07-18 13:39:28 | Re: More than one Cluster on single server (single instance) |
| Previous Message | Guillaume Lelarge | 2022-07-18 09:46:21 | Re: More than one Cluster on single server (single instance) |