Re: Unix domain instead of TCP socket connections with JDBC. - Mailing list pgsql-general

From Tom Lane
Subject Re: Unix domain instead of TCP socket connections with JDBC.
Date
Msg-id 28330.1062994007@sss.pgh.pa.us
Whole thread Raw
In response to Unix domain instead of TCP socket connections with JDBC.  (froggle2003@yahoo.com (Alex Martinoff))
List pgsql-general
froggle2003@yahoo.com (Alex Martinoff) writes:
> ...  Using a TCP socket
> instead of a unix socket seems to slow down requests that return large
> result sets by a factor of 3 on the same machine.

Seems like a kernel bug to me.  All modern TCP stacks have shortcuts for
local connections.  What platform are you on exactly?

(BTW, this is not an argument against having JDBC support unix-socket
connections; I can see security reasons for that.  But there should not
be performance reasons for it.)

            regards, tom lane

pgsql-general by date:

Previous
From: "mathan"
Date:
Subject: Re: Cannot createdb
Next
From: Tom Lane
Date:
Subject: Re: why does count take so long?