From: | Yanrui Hu <yhu(at)appannie(dot)com> |
---|---|
To: | John R Pierce <pierce(at)hogranch(dot)com> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: About the tps explanation of pgbench, please help |
Date: | 2014-11-18 09:46:34 |
Message-ID: | CAP0XUunOHUMhk60ibh3p8tNL+GXyRKo=vp21ZchDdNwxUL9z5A@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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(at)hogranch(dot)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(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>
--
Best Regards,
Yanrui Hu (Ray)
From | Date | Subject | |
---|---|---|---|
Next Message | Francisco Olarte | 2014-11-18 10:26:29 | Re: About the tps explanation of pgbench, please help |
Previous Message | Alban Hertroys | 2014-11-18 08:51:14 | Re: [HACKERS] Performance issue with libpq prepared queries on 9.3 and 9.4 |