MIME-Version: 1.0
References: <CAEzWdqd0SPkZMYNaAbERdgczkfQqLmNV5JBMmF-F9s7KjxJ0gw@mail.gmail.com>
 <CAGsyd8Wc0Oa-863xWE6rcWk4zR=m3tCzhnGdEjvV+UytXjdvrA@mail.gmail.com>
In-Reply-To: <CAGsyd8Wc0Oa-863xWE6rcWk4zR=m3tCzhnGdEjvV+UytXjdvrA@mail.gmail.com>
From: yudhi s <learnerdatabase99@gmail.com>
Date: Sun, 1 Feb 2026 01:09:47 +0530
Message-ID: <CAEzWdqdVG=_6pFjPGHrFnq7+_vLXM1-Z=zH09WnCg9aZukY=XQ@mail.gmail.com>
Subject: Re: Top -N Query performance issue and high CPU usage
To: David Mullineux <dmullx@gmail.com>
Cc: pgsql-general <pgsql-general@lists.postgresql.org>
Content-Type: multipart/alternative; boundary="0000000000005e7b890649b44149"
Archived-At: <https://www.postgresql.org/message-id/CAEzWdqdVG%3D_6pFjPGHrFnq7%2B_vLXM1-Z%3DzH09WnCg9aZukY%3DXQ%40mail.gmail.com>
Precedence: bulk

--0000000000005e7b890649b44149
Content-Type: text/plain; charset="UTF-8"

>
>
>>
> Plan says it's using temp files for sorting....I would suggest you
> increase work_mem for this to avoid temp.fike creation...Although not the
> answer to all your problems, it would be a good start .
>
>
Even setting work_mem to 64MB remove all the "temp read" and showig all
memory reads, but still we are seeing similar cpu spike when executing this
query from multiple sessions and also the response time is staying same.

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

<div dir=3D"ltr"><div class=3D"gmail_quote gmail_quote_container"><blockquo=
te class=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;border-left:1px =
solid rgb(204,204,204);padding-left:1ex"><div dir=3D"auto"><div><div class=
=3D"gmail_quote"><blockquote class=3D"gmail_quote" style=3D"margin:0px 0px =
0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div dir=
=3D"ltr"><br></div></blockquote></div></div><div dir=3D"auto"><br></div><di=
v dir=3D"auto">Plan says it&#39;s using temp files for sorting....I would s=
uggest you increase work_mem for this to avoid temp.fike creation...Althoug=
h not the answer to all your problems, it would be a good start .</div><div=
 dir=3D"auto"><br></div></div></blockquote><div><br></div><div>Even setting=
 work_mem to 64MB remove all the &quot;temp read&quot; and showig all memor=
y reads, but still we are seeing similar cpu spike when executing this quer=
y from multiple sessions and also the response time is staying same.=C2=A0<=
/div></div></div>

--0000000000005e7b890649b44149--