MIME-Version: 1.0
References: <CAG4Txrii4-gTMpGEKLzCSe14svoJGgrh2AY=3LAgmqN2Um=o4A@mail.gmail.com>
 <CAKAnmm+4RLHrKSyedZ+hTkwedP05+Ldp+bHiD00SuJvgAekRgA@mail.gmail.com>
In-Reply-To: <CAKAnmm+4RLHrKSyedZ+hTkwedP05+Ldp+bHiD00SuJvgAekRgA@mail.gmail.com>
From: Ron Johnson <ronljohnsonjr@gmail.com>
Date: Mon, 3 Jun 2024 09:32:26 -0400
Message-ID: <CANzqJaArcMZs841VVvpOyrRfmOx5rnepwB9B-UgM4c=seTW5eA@mail.gmail.com>
Subject: Re: Postgresql 16.3 Out Of Memory
To: pgsql-general <pgsql-general@postgresql.org>
Content-Type: multipart/alternative; boundary="000000000000d78ca90619fc5d10"
Archived-At: <https://www.postgresql.org/message-id/CANzqJaArcMZs841VVvpOyrRfmOx5rnepwB9B-UgM4c%3DseTW5eA%40mail.gmail.com>
Precedence: bulk

--000000000000d78ca90619fc5d10
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

On Mon, Jun 3, 2024 at 9:12=E2=80=AFAM Greg Sabino Mullane <htamfids@gmail.=
com>
wrote:

> On Mon, Jun 3, 2024 at 6:19=E2=80=AFAM Radu Radutiu <rradutiu@gmail.com> =
wrote:
>
>> Do you have any idea how to further debug the problem?
>>
>
> Putting aside the issue of non-reclaimed memory for now, can you show us
> the actual query? The explain analyze you provided shows it doing an awfu=
l
> lot of joins and then returning 14+ million rows to the client. Surely th=
e
> client does not need that many rows?
>

And the query cost is really high.  "Did you ANALYZE the instance after
conversion?" was my first question.

--000000000000d78ca90619fc5d10
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr"><div dir=3D"ltr">On Mon, Jun 3, 2024 at 9:12=E2=80=AFAM Gr=
eg Sabino Mullane &lt;<a href=3D"mailto:htamfids@gmail.com">htamfids@gmail.=
com</a>&gt; wrote:<br></div><div class=3D"gmail_quote"><blockquote class=3D=
"gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(2=
04,204,204);padding-left:1ex"><div dir=3D"ltr"><div dir=3D"ltr">On Mon, Jun=
 3, 2024 at 6:19=E2=80=AFAM Radu Radutiu &lt;<a href=3D"mailto:rradutiu@gma=
il.com" target=3D"_blank">rradutiu@gmail.com</a>&gt; wrote:=C2=A0<br></div>=
<div class=3D"gmail_quote"><blockquote class=3D"gmail_quote" style=3D"margi=
n:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex=
"><div dir=3D"ltr"><div>Do you have any idea how to further debug the probl=
em?=C2=A0</div></div></blockquote><div><br></div><div>Putting aside the iss=
ue of non-reclaimed memory for now, can you show us the actual query? The e=
xplain analyze you provided shows it doing an awful lot of joins and then r=
eturning 14+ million rows to the client. Surely the client does not need th=
at many rows?</div></div></div></blockquote><div><br></div><div>And the que=
ry cost is really high.=C2=A0 &quot;Did you ANALYZE the instance after conv=
ersion?&quot; was my first question.</div></div></div>

--000000000000d78ca90619fc5d10--