if I "alter table allwise set (parallel_workers = 64);" then I can get 64
workers. I wonder if the code
to check the rel_parallel_workers do deal with the default algorithm not
allocating sufficient
parallel_workers.
On Mon, Jul 14, 2025 at 2:54 PM Tom Lane wrote:
> Greg Hen
g
On Fri, Jul 11, 2025 at 2:11 PM Weck, Luis wrote:
> *From: *Greg Hennessy
> *Date: *Thursday, July 10, 2025 at 4:40 PM
> *To: * pgsql-general@lists.postgresql.org <
> pgsql-general@lists.postgresql.org>
> *Subject: *optimizing number of workers
>
> Having just recei
Having just received a shiny new dual CPU machine to use as a postgresql
server, I'm trying to do some reasonable efforts to configure it correctly.
The hard
ware has 128 cores, and I am running a VM with Redhat 9 and Postgresql
16.9.
In postgresql.conf I have:
max_worker_processes = 90
Just to install the program, I got several errors without any common
sense, I asked the Microsoft support team for help and in 5 minutes
they solved the problem, it's very weird and odd. Apparently they have
control of my personal computer.
Are you sure you were talking to Microsoft, rathe
