public inbox for [email protected]  

help / color / mirror / Atom feed

From: Rob Sargent <[email protected]>
To: [email protected]
Subject: Re: High latency and profiling
Date: Thu, 9 Oct 2025 14:54:56 -0600
Message-ID: <[email protected]> (raw)
In-Reply-To: <[email protected]>
References: <[email protected]>
	<[email protected]>



On 10/9/25 13:21, Laurenz Albe wrote:
> 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.
Thankfully I checked before sending very similar remarks as Laurenz's 
below.  I find OP's pair of sentences (borderline) self-contradictory.


>> 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
>>
>>
>>

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]
  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