Re: waiting for client write

2021-06-12 Thread Ayub Khan
Ranier, Vijay, Sure will try and check out pgbench and MTU --Ayub On Wed, 9 Jun 2021, 17:47 Ayub Khan, 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.

Re: waiting for client write

2021-06-12 Thread Vijaykumar Jain
since you are willing to try out options :) if your setup runs the same test plan queries on jmeter against oracle and postgresql and only postgresql shows waits or degraded performance I think this is more then simply network. can you simply boot up an ec2 ubuntu/centos and install postgresql. a

Re: waiting for client write

2021-06-12 Thread Ranier Vilela
Em sáb., 12 de jun. de 2021 às 05:20, Ayub Khan escreveu: > Ranier, > > This issue is only with queries which are slow, if it's an MTU issue then > it should be with all the APIs. > > I tried on Aurora db and I see same plan and also same slowness > I think it is more indicative that the problem

Re: waiting for client write

2021-06-12 Thread Ayub Khan
Ranier, This issue is only with queries which are slow, if it's an MTU issue then it should be with all the APIs. I tried on Aurora db and I see same plan and also same slowness On Wed, 9 Jun 2021, 17:47 Ayub Khan, wrote: > attached is the screenshot of RDS performance insights for AWS and it