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

From: Chris Withers <chris(at)simplistix(dot)co(dot)uk>
To: pgsql-general(at)postgresql(dot)org
Subject: pgbench tps drop from 5000 to 37 going from localhost to a server 13ms away
Date: 2015-07-24 16:59:03
Message-ID: 55B26ED7.7010909@simplistix.co.uk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Jeff Janes 2015-07-24 17:07:00 Re: Using the database to validate data
Previous Message Jeff Janes 2015-07-24 16:47:16 Re: Using the database to validate data