Re: optimizing number of workers

2025-07-15 Thread Greg Hennessy
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 Hennessy writes: > >>

Re: optimizing number of workers

2025-07-14 Thread Tom Lane
Greg Hennessy writes: >> Postgres has chosen to use only a small fraction of the CPU's I have on >> my machine. Given the query returns an answer in about 8 seconds, it may be >> that Postgresql has allocated the proper number of works. But if I wanted >> to try to tweak some config parameters to

Re: optimizing number of workers

2025-07-14 Thread Greg Hennessy
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

Re: optimizing number of workers

2025-07-11 Thread Weck, Luis
From: Greg Hennessy Date: Thursday, July 10, 2025 at 4:40 PM To: pgsql-general@lists.postgresql.org Subject: optimizing number of workers 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

optimizing number of workers

2025-07-10 Thread Greg Hennessy
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