From: | Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at> |
---|---|
To: | Pól Ua Laoínecháin <linehanp(at)tcd(dot)ie>, pgsql-novice(at)lists(dot)postgresql(dot)org |
Subject: | Re: Using PGTune - is it a good source for system configuration? |
Date: | 2021-09-01 18:01:48 |
Message-ID: | 7d31e25d6cdd46ab94559179268e61413849d741.camel@cybertec.at |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
On Wed, 2021-09-01 at 17:19 +0100, Pól Ua Laoínecháin wrote:
> I used PGTune to obtain system configuration recommendations. I'm
> wondering if these can be taken as "gospel" or are there any caveats
> or "gotchas" to be aware of?
It is a serving suggestion and gives you food for thought.
It does not substitute thinking for yourself and reading the documentation
for those parameters.
> # DB Version: 13
> # OS Type: linux
> # DB Type: mixed
> # Total Memory (RAM): 32 GB
> # CPUs num: 2
> # Data Storage: ssd
>
> max_parallel_workers_per_gather = 1
> max_parallel_workers = 2
> max_parallel_maintenance_workers = 1
For example, I think these are not sane values for a mixed workload
with 2 CPU cores.
With that configuration, a single query could keep both cores busy.
I'd set all these to 0.
Yours,
Laurenz Albe
--
Cybertec | https://www.cybertec-postgresql.com
From | Date | Subject | |
---|---|---|---|
Next Message | Pól Ua Laoínecháin | 2021-09-01 18:16:18 | Re: Using PGTune - is it a good source for system configuration? |
Previous Message | Roger Mason | 2021-09-01 17:56:07 | Re: trigger fails |