Search Postgresql Archives

Re: About the tps explanation of pgbench, please help

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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@xxxxxxxxxxxx> 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@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general



--
Best Regards,

Yanrui Hu (Ray)

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux