From: | Pól Ua Laoínecháin <linehanp(at)tcd(dot)ie> |
---|---|
To: | |
Cc: | pgsql-novice <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:16:18 |
Message-ID: | CAF4RT5QJ0gAVqqiNJ2-2WMcGVsWhihBwif+zttw08pT-W0jv1w@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
Hi, and thanks for replying.
> Not according to its "about" page...
Yeah, sure, it's not a silver bullet, but the thrust of my question
was: do the community experts consider it reliable enough as a first
approximation?
Your remarks about "better than the generic defaults" reassures me
that this is the case.
This is just my laptop - but I've taken PGTune's recommendations
before for a data loading and it was a real help...
One other question that I forgot to include in my original!
I have a two CPU core (that's why I put 2 for the number of CPUs) but
my processor supports hyperthreading (Intel Core i5, 7th Gen), so
should I really put 4 as the no.
Changing this from 2 to 4 changes the
work_mem from 41943kB to 20971kB and the worker settings from
max_worker_processes = 2
max_parallel_workers_per_gather = 1
max_parallel_workers = 2
max_parallel_maintenance_workers = 1
to
max_worker_processes = 4
max_parallel_workers_per_gather = 2
max_parallel_workers = 4
max_parallel_maintenance_workers = 2
So, which would be the correct Number of CPUs setting given my processor?
TIA and rgs,
Pól...
> David J.
From | Date | Subject | |
---|---|---|---|
Next Message | Stephen Froehlich | 2021-09-01 22:41:14 | RE: Using PGTune - is it a good source for system configuration? |
Previous Message | Laurenz Albe | 2021-09-01 18:01:48 | Re: Using PGTune - is it a good source for system configuration? |