public inbox for [email protected]
help / color / mirror / Atom feedFrom: Adrian Klaver <[email protected]>
To: yudhi s <[email protected]>
To: pgsql-general <[email protected]>
Subject: Re: Top -N Query performance issue and high CPU usage
Date: Sat, 31 Jan 2026 08:14:48 -0800
Message-ID: <[email protected]> (raw)
In-Reply-To: <CAEzWdqd0SPkZMYNaAbERdgczkfQqLmNV5JBMmF-F9s7KjxJ0gw@mail.gmail.com>
References: <CAEzWdqd0SPkZMYNaAbERdgczkfQqLmNV5JBMmF-F9s7KjxJ0gw@mail.gmail.com>
On 1/31/26 05:30, yudhi s wrote:
> Hello Experts,
> This query is going to be called in the first page of an UI screen and
> is supposed to show the latest 1000 rows based on a certain transaction
> date. This query is supposed to allow thousands of users to hit this
> same query at the first landing page at the same time. Its postgres
> version 17. The instance has 2-VCPU and 16GB RAM.
1) Without even looking at the plan I'm going to say 2-VCPU and 16GB RAM
and is insufficient resources for what you want to do.
2) You will need to provide the schema definitions for the tables involved.
4)And based on the CPU core and memory , is there any calculation by
using which , we can say that this machine can support a maximum N
number of concurrent queries of such type beyond which we need more cpu
cores machines?
You already have the beginnings of a chart:
1 session 2-3 secs
10-15 sessions 50-60% usage
40-50 sessions 90% usage
>
> Regards
> Yudhi
--
Adrian Klaver
[email protected]
view thread (24+ 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: <[email protected]>
* 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