Postgres Pro
Downloads
Home   >   mailing lists

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

From Yanrui Hu
Subject Re: About the tps explanation of pgbench, please help
Date
Msg-id CAP0XUunOHUMhk60ibh3p8tNL+GXyRKo=vp21ZchDdNwxUL9z5A@mail.gmail.com
Whole thread Raw
In response to Re: About the tps explanation of pgbench, please help  (John R Pierce <pierce@hogranch.com>)
Responses Re: About the tps explanation of pgbench, please help
List pgsql-general
Tree view
It the "connection establishing" means socket connect? If so, that 's the only different for my case A and B.
So the result of "exclude connection establishing" should be similar, right?

My overall test is to fingure out the what's the impact if my client access db server from out side datacenter( eg. internet).

On Tue, Nov 18, 2014 at 4:39 PM, John R Pierce <pierce@hogranch.com> wrote:
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



--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general



--
Best Regards,

Yanrui Hu (Ray)

pgsql-general by date:

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