Commit Latency

From: Ramakrishna m <ram(dot)pgdb(at)gmail(dot)com>
To: pgsql-general(at)lists(dot)postgresql(dot)org
Cc: ravisql09(at)gmail(dot)com
Subject: Commit Latency
Date: 2025-02-05 10:18:54
Message-ID: CAG-eXHLT2Fgw_szi3KUd8a2AE7cgzBsdi3MaUaGb=TQ+w7oV4w@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

HI Team,
I have a system handling *300 TPS*, with resource usage *below 10%*.
However, I’m noticing *commit latency of around 200ms* for *1% of
transactions*, occasionally spiking to *1 second*. Since there is no
significant *I/O pressure*, I’m trying to identify what else might be
causing this in *PostgreSQL 16*.

Below are the parameters, Version and OS details.

[image: image.png]

Regards,
Ram.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Michał Kłeczek 2025-02-05 12:55:51 Re: Lookup tables
Previous Message Michał Kłeczek 2025-02-05 05:44:49 Re: Lookup tables