Re: Strange result: UNIX vs. TCP/IP sockets

От: Tom Lane
Тема: Re: Strange result: UNIX vs. TCP/IP sockets
Дата: ,
Msg-id: 8908.1057355247@sss.pgh.pa.us
(см: обсуждение, исходный текст)
Ответ на: Re: Strange result: UNIX vs. TCP/IP sockets  (Andrew Sullivan)
Ответы: Re: Strange result: UNIX vs. TCP/IP sockets  (Andrew Sullivan)
Список: pgsql-performance

Скрыть дерево обсуждения

Strange result: UNIX vs. TCP/IP sockets  (Andrew Sullivan, )
 Re: Strange result: UNIX vs. TCP/IP sockets  (The Hermit Hacker, )
  Re: Strange result: UNIX vs. TCP/IP sockets  (Vincent van Leeuwen, )
   Re: Strange result: UNIX vs. TCP/IP sockets  (Andrew Sullivan, )
    Re: Strange result: UNIX vs. TCP/IP sockets  (Tom Lane, )
     Re: Strange result: UNIX vs. TCP/IP sockets  (Andrew Sullivan, )
 Re: Strange result: UNIX vs. TCP/IP sockets  (Rod Taylor, )
 Re: Strange result: UNIX vs. TCP/IP sockets  (Andrew Sullivan, )

Andrew Sullivan <> writes:
> How could it be the transport affects the time for the query as
> reported by the back end?

How much data is being sent back by the query?

Do you have SSL enabled?  SSL encryption overhead is nontrivial,
especially if any renegotiations happen.

            regards, tom lane


В списке pgsql-performance по дате сообщения:

От: "Bjoern Metzdorf"
Дата:
Сообщение: Re: PostgreSQL vs. MySQL
От: Grega Bremec
Дата:
Сообщение: Re: PostgreSQL vs. MySQL