Re: Parallelize correlated subqueries that execute within each worker

Поиск
Список
Период
Сортировка
От Richard Guo
Тема Re: Parallelize correlated subqueries that execute within each worker
Дата
Msg-id CAMbWs4-=RZ8JKkEzc6qrX_YJbp0WnfM9++2dQHdshsq0bz1+2Q@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Parallelize correlated subqueries that execute within each worker  (James Coleman <jtc331@gmail.com>)
Список pgsql-hackers
Дерево обсуждения

On Mon, Jun 12, 2023 at 10:23 AM James Coleman <jtc331@gmail.com> wrote:
BTW are you by any chance testing on ARM macOS? I reproduced the issue
there, but for some reason I did not reproduce the error (and the plan
wasn't parallelized) when I tested this on linux. Perhaps I missed
setting something up; it seems odd.

Hmm, that's weird.  I was also testing that query on linux.  But please
note that several GUC settings are needed to generate parallel plan for
that query.

set min_parallel_table_scan_size to 0;
set parallel_setup_cost to 0;
set parallel_tuple_cost to 0;

Thanks
Richard

В списке pgsql-hackers по дате отправления:

Предыдущее
От: Ronan Dunklau
Дата:
Сообщение: Re: Add GUC to tune glibc's malloc implementation.
Следующее
От: Heikki Linnakangas
Дата:
Сообщение: Improve comment on cid mapping (was Re: Adding CommandID to heap xlog records)