| From: | Niels Jespersen <NJN(at)dst(dot)dk> |
|---|---|
| To: | David Rowley <dgrowleyml(at)gmail(dot)com> |
| Cc: | "pgsql-general(at)lists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org> |
| Subject: | SV: cpu-intensive immutable function and parallel scan |
| Date: | 2021-06-23 04:57:09 |
| Message-ID: | 90e5e03eeb1c4eb8946e8ac1556c0ab4@dst.dk |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
>Fra: David Rowley <dgrowleyml(at)gmail(dot)com> Sendt: 22. juni 2021 09:10
>Emne: Re: cpu-intensive immutable function and parallel scan
>On Tue, 22 Jun 2021 at 19:06, Niels Jespersen <NJN(at)dst(dot)dk> wrote:
>> I think I could achieve some speedup by parallelizing further, distributing the cpu-work among additional workers. But, how do I achive that best?
>You'll want to ensure max_parallel_workers_per_gather is set high enough and you have max_parallel_workers set to something high enough.
>You can then do:
>alter table t1 set (parallel_workers = <number of workers>);
Thank you. That helped. A lot.
/Niels
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Darafei Komяpa Praliaskouski | 2021-06-23 09:26:55 | Re: [postgis-users] Exclusion constraint with custom operator not working as expected |
| Previous Message | Rhys A.D. Stewart | 2021-06-22 20:29:34 | Exclusion constraint with custom operator not working as expected |