Postgres Pro
Downloads
Home   >   mailing lists

Re: About the tps explanation of pgbench, please help - Mailing list pgsql-general

From John R Pierce
Subject Re: About the tps explanation of pgbench, please help
Date
Msg-id 546B05BC.3010801@hogranch.com
Whole thread Raw
In response to About the tps explanation of pgbench, please help  (Yanrui Hu <yhu@appannie.com>)
Responses Re: About the tps explanation of pgbench, please help  (Yanrui Hu <yhu@appannie.com>)
List pgsql-general
Tree view 
On 11/18/2014 12:33 AM, Yanrui Hu wrote:
> the tps excluding connections establishing should be very close,
> right? Because the database is same and capability is same only
> network latency is different.

that greatly latency is added to every sql command you send and get
results from.   why would you expect anything different?

--
john r pierce                                      37N 122W
somewhere on the middle of the left coast

pgsql-general by date:

Previous
From: Yanrui Hu
Date:
Subject: About the tps explanation of pgbench, please help
Next
From: Alban Hertroys
Date:
Subject: Re: [HACKERS] Performance issue with libpq prepared queries on 9.3 and 9.4