public inbox for [email protected]
help / color / mirror / Atom feedFrom: Laurenz Albe <[email protected]>
To: Pól Ua Laoínecháin <[email protected]>
To: [email protected]
Subject: Re: Using PGTune - is it a good source for system configuration?
Date: Wed, 01 Sep 2021 20:01:48 +0200
Message-ID: <[email protected]> (raw)
In-Reply-To: <CAF4RT5RfAuwnAycn9pU+Hxqv1aaKiAnQKv0V_BsqjSX5TAymtw@mail.gmail.com>
References: <CAF4RT5RfAuwnAycn9pU+Hxqv1aaKiAnQKv0V_BsqjSX5TAymtw@mail.gmail.com>
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
view thread (5+ messages) latest in thread
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: [email protected]
Cc: [email protected], [email protected], [email protected]
Subject: Re: Using PGTune - is it a good source for system configuration?
In-Reply-To: <[email protected]>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox