> For parallelism, there are these options
That only matters if you want to use those extra cores to make individual
queries / commands faster.
If all OP cares about is "will PG use my extra cores", the answer is yes it
will without doing anything special.
Hi,
> On 11. Jun 2020, at 10:24, Sujith Kumar.S wrote:
>
> Is there any configuration in postgresql that restrict the number of CPU
> usage by postgres process.
For parallelism, there are these options:
- max_parallel_workers_per_gather
- max_parallel_workers
- max_worker_processes
Where the
On 6/11/20 1:24 AM, Sujith Kumar.S wrote:
Hi Team,
Could you please confirm whether I need to restart my postgresql
instance after adding CPU to my server.
You did that while it was running?
Is there any configuration in postgresql that restrict the number of CPU
usage by postgres process
Hi Team,
Could you please confirm whether I need to restart my postgresql instance
after adding CPU to my server.
Is there any configuration in postgresql that restrict the number of CPU
usage by postgres process.
