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

From: Tom Lane
Subject: Re: Strange result: UNIX vs. TCP/IP sockets
Date: ,
Msg-id: 8908.1057355247@sss.pgh.pa.us
(view: Whole thread, Raw)
In response to: Re: Strange result: UNIX vs. TCP/IP sockets  (Andrew Sullivan)
Responses: Re: Strange result: UNIX vs. TCP/IP sockets  (Andrew Sullivan)
List: pgsql-performance

Tree view

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 by date:

From: "Bjoern Metzdorf"
Date:
Subject: Re: PostgreSQL vs. MySQL
From: Grega Bremec
Date:
Subject: Re: PostgreSQL vs. MySQL