Re: waiting for client write

Ranier, I did the MTU change and it did seem to bring down the clientWrite waits to half. The change I did was to enable ICMP to have Destination Unreachable fragmentation needed and DF set "When there is a difference in the MTU size in the network between two hosts, first make sure that your ne

Re: waiting for client write

thanks. >latency average = 2480.042 ms that latency is pretty high, even after changing the mtu ? for a query that takes 5ms to run (from your explain analyze above) and returns a few 100 rows. so it does look like a network latency, but it seems strange when you said the same query from the sam

Re: waiting for client write

Vijay, I did not change the MTU on the network interface but created incoming rule on the security group as per the below documentation: PMTUD enables the receiving host to respond to the originating host with the following ICMP message: Destination Unreachable: fragmentation needed and DF set

Re: waiting for client write

Vijay, below is the benchmark result when executed against bench_mark database instead of running the test with slow query on the application database. This shows that it might not be an issue with MTU but some issue with the application database itself and the query. postgres@localhost:~$ pgben