public inbox for [email protected]  

help / color / mirror / Atom feed

From: yudhi s <[email protected]>
To: Rob Sargent <[email protected]>
To: pgsql-general <[email protected]>
Subject: Re: Top -N Query performance issue and high CPU usage
Date: Mon, 2 Feb 2026 12:03:08 +0530
Message-ID: <CAEzWdqfZ6mbtjM1GPBp1LthS=MGUYng3Pw6hj+g6+054BA4VqA@mail.gmail.com> (raw)
In-Reply-To: <[email protected]>
References: <CAEzWdqf+b+7JDRNzJVqWKyF8N8Aa2CZC5B_o1xZLDWozqV-RUA@mail.gmail.com>
	<[email protected]>

On Mon, 2 Feb, 2026, 11:21 am Rob Sargent, <[email protected]> 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’s earlier descriptions to suggest that each login 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’t get much help here on the latter problem without 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.

view thread (2+ messages)  latest in thread

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected], [email protected], [email protected]
  Subject: Re: Top -N Query performance issue and high CPU usage
  In-Reply-To: <CAEzWdqfZ6mbtjM1GPBp1LthS=MGUYng3Pw6hj+g6+054BA4VqA@mail.gmail.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox