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
