Postgres Pro
Downloads
Home   >   mailing lists

Re: OOM in hash join - Mailing list pgsql-hackers

From Thomas Munro
Subject Re: OOM in hash join
Date
Msg-id CA+hUKGJxn1fOTtLU07rrzUrnMuuG6yzu+qBUmyiWgJdacD4fHw@mail.gmail.com
Whole thread Raw
In response to Re: OOM in hash join  (Jehan-Guillaume de Rorthais <jgdr@dalibo.com>)
List pgsql-hackers
Tree view 
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 by date:

Previous
From: Merlin Moncure
Date:
Subject: Re: Request for comment on setting binary format output per session
Next
From: Etsuro Fujita
Date:
Subject: Re: postgres_fdw: wrong results with self join + enable_nestloop off