From: | Andres Freund <andres(at)anarazel(dot)de> |
---|---|
To: | Pantelis Theodosiou <ypercube(at)gmail(dot)com> |
Cc: | Radu Radutiu <rradutiu(at)gmail(dot)com>, pgsql-hackers(at)lists(dot)postgresql(dot)org |
Subject: | Re: Postgresql OOM |
Date: | 2024-06-07 17:04:19 |
Message-ID: | 20240607170419.ov2mxw7vtjlal7mf@awork3.anarazel.de |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
Hi,
On 2024-06-06 13:58:24 +0100, Pantelis Theodosiou wrote:
> I am not qualified to answer on the OOM issue but why are you joining the
> same table (outputrequest) 4 times (using an identical join condition)?
The conditions aren't actually the same
rpl_rec_tro. input_sequence = r.input_sequence
rpl_snd_tro.reply_input_sequence = r.input_sequence
snd_tro. reply_input_sequence = t.input_sequence
First two are r.input_sequence to different columns, the third one also uses
reply_input_sequence but joins to t, not r.
Greetings,
Andres Freund
From | Date | Subject | |
---|---|---|---|
Next Message | Jacob Champion | 2024-06-07 17:14:50 | Re: Re: Add support to TLS 1.3 cipher suites and curves lists |
Previous Message | Andres Freund | 2024-06-07 16:59:07 | Re: Postgresql OOM |