Re: About the tps explanation of pgbench, please help

Поиск
Список
Период
Сортировка
От Yanrui Hu
Тема Re: About the tps explanation of pgbench, please help
Дата
Msg-id CAP0XUunOHUMhk60ibh3p8tNL+GXyRKo=vp21ZchDdNwxUL9z5A@mail.gmail.com
обсуждение исходный текст
Ответ на Re: About the tps explanation of pgbench, please help  (John R Pierce <pierce@hogranch.com>)
Ответы Re: About the tps explanation of pgbench, please help  (Francisco Olarte <folarte@peoplecall.com>)
Список 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@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 по дате отправления:

Предыдущее
От: Alban Hertroys
Дата:
Сообщение: Re: [HACKERS] Performance issue with libpq prepared queries on 9.3 and 9.4
Следующее
От: Francisco Olarte
Дата:
Сообщение: Re: About the tps explanation of pgbench, please help