public inbox for [email protected]  

help / color / mirror / Atom feed

From: Laurenz Albe <[email protected]>
To: Roberto Nunnari <[email protected]>
To: [email protected]
Subject: Re: High latency and profiling
Date: Thu, 09 Oct 2025 21:21:19 +0200
Message-ID: <[email protected]> (raw)
In-Reply-To: <[email protected]>
References: <[email protected]>

On Thu, 2025-10-09 at 19:25 +0200, Roberto Nunnari wrote:
> I was notified about high latency on one of our PostgreSQL clusters.
> This latency is observed from the application and has been increasing. 
> There is no indication about the exact database as the application uses 
> several DBs, but the largest and most used is 'mydb'.
>
> Developers report that their software is already optimized and database 
> size is not a problem. They suggest the issue might be inside PostgreSQL 
> itself.

That may be true, but it need not be true.  The developers' statement
sounds a bit overconfident.

> Could somebody help me understand what is causing the growing latency?

For that, you have to identify the statements that run longer than they
should.  Then examine them with EXPLAIN (ANALYZE, BUFFERS), figure out what
makes them slow and improve them.

Yours,
Laurenz Albe

view thread (2+ messages)

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: High latency and profiling
  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