Re: OOM in hash join

Поиск
Список
Период
Сортировка
От Thomas Munro
Тема Re: OOM in hash join
Дата
Msg-id CA+hUKGJxn1fOTtLU07rrzUrnMuuG6yzu+qBUmyiWgJdacD4fHw@mail.gmail.com
обсуждение исходный текст
Ответ на Re: OOM in hash join  (Jehan-Guillaume de Rorthais <jgdr@dalibo.com>)
Список pgsql-hackers
On Fri, Apr 14, 2023 at 11:43 PM Jehan-Guillaume de Rorthais
<jgdr@dalibo.com> wrote:
> Would you be able to test the latest patchset posted [1] ? This does not fix
> the work_mem overflow, but it helps to keep the number of batches
> balanced and acceptable. Any feedback, comment or review would be useful.
>
> [1] https://www.postgresql.org/message-id/flat/20230408020119.32a0841b%40karst#616c1f41fcc10e8f89d41e8e5693618c

Hi Jehan-Guillaume.  I hadn't paid attention to that thread before
probably due to timing and the subject and erm ETOOMANYTHREADS.
Thanks for all the work you've done to study this area and also review
and summarise the previous writing/patches/ideas.



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

Предыдущее
От: Merlin Moncure
Дата:
Сообщение: Re: Request for comment on setting binary format output per session
Следующее
От: Etsuro Fujita
Дата:
Сообщение: Re: postgres_fdw: wrong results with self join + enable_nestloop off