Re: TCP network cost

From: Tom Lane
Subject: Re: TCP network cost
Date: ,
Msg-id: 13121.1235929398@sss.pgh.pa.us
(view: Whole thread, Raw)
In response to: Re: TCP network cost  (Linos)
Responses: Re: TCP network cost  (Linos)
List: pgsql-performance

Tree view

TCP network cost  ("Ross J. Reedstrom", )
 Re: TCP network cost  (Rusty Conover, )
  Re: TCP network cost  (, )
  Re: TCP network cost  ("Ross J. Reedstrom", )
   Re: TCP network cost  (Rusty Conover, )
    Re: TCP network cost  ("Ross J. Reedstrom", )
     Re: TCP network cost  ("Ross J. Reedstrom", )
      Re: TCP network cost  (Aaron Turner, )
     Re: TCP network cost  (PFC, )
      Re: TCP network cost  ("Ross J. Reedstrom", )
   Re: TCP network cost  (Gregory Stark, )
    Re: TCP network cost  ("Ross J. Reedstrom", )
     Re: TCP network cost  (Tom Lane, )
      Re: TCP network cost  ("Ross J. Reedstrom", )
       Re: TCP network cost  (Linos, )
        Re: TCP network cost  (Tom Lane, )
         Re: TCP network cost  (Linos, )
          Re: TCP network cost  (Tom Lane, )
           Re: TCP network cost  (Linos, )
            Re: TCP network cost  (Tom Lane, )
             Re: TCP network cost  (Magnus Hagander, )
              Re: TCP network cost  (Linos, )
 Re: TCP network cost  (Aaron Turner, )

Linos <> writes:
> Hello, i have been having a problem like this in debian machines and i have
> discovered that (almost in my case), the problem only arises when i am using
> "ssl = true" in postgresql.conf although i am using clear tcp connections to
> localhost to perform my query, if i disable ssl in configuration my localhost
> query times goes from 4200ms to 110ms,

Does that number include connection startup overhead?  (If it doesn't,
it'd be pretty strange.)  Ross's problem is not about startup overhead,
unless I've misread him completely.

            regards, tom lane


pgsql-performance by date:

From: "Cox, Brian"
Date:
Subject: Re: "slow" queries
From: Tom Lane
Date:
Subject: Re: "slow" queries