Re: waiting for client write

From: Magnus Hagander <magnus(at)hagander(dot)net>
To: Ayub Khan <ayub(dot)hp(at)gmail(dot)com>
Cc: Pgsql Performance <pgsql-performance(at)lists(dot)postgresql(dot)org>
Subject: Re: waiting for client write
Date: 2021-06-09 14:49:38
Message-ID: CABUevEwL3=PLSOfX3w=a3YtHga8HkwQDLhFmLWAyLqkcYofaYQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On Wed, Jun 9, 2021 at 4:47 PM Ayub Khan <ayub(dot)hp(at)gmail(dot)com> wrote:
>
> attached is the screenshot of RDS performance insights for AWS and it shows high waiting client writes. The api performance is slow. I read that this might be due to IOPS on RDS. However we have 80k IOPS on this test RDS.
>

ClientWrite means Postgres is waiting on the *network* sending the
reply back to the client, it is unrelated to I/O. So either your
client isn't consuming the response fast enough, or the network
between them is too slow or shaped.

--
Magnus Hagander
Me: https://www.hagander.net/
Work: https://www.redpill-linpro.com/

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Ayub Khan 2021-06-09 18:59:17 Re: waiting for client write
Previous Message Ayub Khan 2021-06-09 14:47:02 waiting for client write