pgbench tps drop from 5000 to 37 going from localhost to a server 13ms away - Mailing list pgsql-general

From Chris Withers
Subject pgbench tps drop from 5000 to 37 going from localhost to a server 13ms away
Date
Msg-id 55B26ED7.7010909@simplistix.co.uk
Whole thread Raw
Responses Re: pgbench tps drop from 5000 to 37 going from localhost to a server 13ms away
List pgsql-general
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


pgsql-general by date:

Previous
From: Jeff Janes
Date:
Subject: Re: Using the database to validate data
Next
From: Jeff Janes
Date:
Subject: Re: Using the database to validate data