MIME-Version: 1.0
References: <CAEzWdqf+b+7JDRNzJVqWKyF8N8Aa2CZC5B_o1xZLDWozqV-RUA@mail.gmail.com>
 <63F54040-608A-4ED4-A23C-E6767FF87088@gmail.com>
In-Reply-To: <63F54040-608A-4ED4-A23C-E6767FF87088@gmail.com>
From: yudhi s <learnerdatabase99@gmail.com>
Date: Mon, 2 Feb 2026 12:03:08 +0530
Message-ID: <CAEzWdqfZ6mbtjM1GPBp1LthS=MGUYng3Pw6hj+g6+054BA4VqA@mail.gmail.com>
Subject: Re: Top -N Query performance issue and high CPU usage
To: Rob Sargent <robjsargent@gmail.com>, 
	pgsql-general <pgsql-general@lists.postgresql.org>
Content-Type: multipart/alternative; boundary="000000000000b1b3f50649d17f75"
Archived-At: <https://www.postgresql.org/message-id/CAEzWdqfZ6mbtjM1GPBp1LthS%3DMGUYng3Pw6hj%2Bg6%2B054BA4VqA%40mail.gmail.com>
Precedence: bulk

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

On Mon, 2 Feb, 2026, 11:21 am Rob Sargent, <robjsargent@gmail.com> wrote:

>
> > Thank you so much. I need to get back on the exact number of such
> queries which can hit the database. However, as 1000 of users will be
> there, so the possibility of all logging into the system on the same page
> at same time needs to be found out. Will double check on this.
> >
> > However,  when you said caching :- The results on the base tables are
> going to be ~30-50 million. This landing page has filters on it so it may
> be of 30+ different
>
> I know I read OP=E2=80=99s earlier descriptions to suggest that each logi=
n saw the
> same data. I was wrong and I suspect the suggestion to cache goes out the
> window.
>
> The need for more resources now comes centre stage, right beside query
> tuning. You won=E2=80=99t get much help here on the latter problem withou=
t more DDL
> on the tables involved. Help on the hardware is just money - though most
> desktops these days are more powerful than that vert described up-thread


Won't , the materialized view having a minimum Delta refresh frequency(5-10
> minutes?) help in such scenarios? As the overhead of the query complexity
> will lie within the materialized view and it can be indexed as per the
> dynamic incoming filter conditions.

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

<div dir=3D"auto"><br><br><div class=3D"gmail_quote gmail_quote_container" =
dir=3D"auto"><div dir=3D"ltr" class=3D"gmail_attr">On Mon, 2 Feb, 2026, 11:=
21 am Rob Sargent, &lt;<a href=3D"mailto:robjsargent@gmail.com">robjsargent=
@gmail.com</a>&gt; wrote:<br></div><blockquote class=3D"gmail_quote" style=
=3D"margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><br>
&gt; Thank you so much. I need to get back on the exact number of such quer=
ies which can hit the database. However, as 1000 of users will be there, so=
 the possibility of all logging into the system on the same page at same ti=
me needs to be found out. Will double check on this.<br>
&gt; <br>
&gt; However,=C2=A0 when you said caching :- The results on the base tables=
 are going to be ~30-50 million. This landing page has filters on it so it =
may be of 30+ different<br>
<br>
I know I read OP=E2=80=99s earlier descriptions to suggest that each login =
saw the same data. I was wrong and I suspect the suggestion to cache goes o=
ut the window. <br>
<br>
The need for more resources now comes centre stage, right beside query tuni=
ng. You won=E2=80=99t get much help here on the latter problem without more=
 DDL on the tables involved. Help on the hardware is just money - though mo=
st desktops these days are more powerful than that vert described up-thread=
</blockquote></div><div dir=3D"auto"><br></div><div class=3D"gmail_quote gm=
ail_quote_container" dir=3D"auto"><blockquote class=3D"gmail_quote" style=
=3D"margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">Won&#39;=
t , the materialized view having a minimum Delta refresh frequency(5-10 min=
utes?) help in such scenarios? As the overhead of the query complexity will=
 lie within the materialized view and it can be indexed as per the dynamic =
incoming filter conditions.=C2=A0</blockquote></div></div>

--000000000000b1b3f50649d17f75--