Re: pgbench tps drop from 5000 to 37 going from localhost to a server 13ms away

That seems to be a large drop. On the other hand 13 ms is also like a very large network latency. On LAN your usually in the sub ms area. So going from e.g. 0.2 ms to 13ms is 65 fold decrease. What is the network toplogy like?

Jan

Von meinem iPad gesendet

> Am 24.07.2015 um 18:59 schrieb Chris Withers <chris(at)simplistix(dot)co(dot)uk>:
>
> Hi all,
>
> I've been doing some lightweight load testing with
> “pgbench -c8 -j8 -T10”
>
> When run locally on the postgres server I've testing, this gives around 5000tps
>
> When I do it from a server that has a 13ms ping latency, it drops to 37tps.
>
> This is using the default pgbench script, is it to be expected?
> If so, why?
>
> cheers,
>
> Chris
>
>
> --
> Sent via pgsql-general mailing list (pgsql-general(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general