Re: Unix domain instead of TCP socket connections with JDBC.

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: froggle2003(at)yahoo(dot)com (Alex Martinoff)
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Unix domain instead of TCP socket connections with JDBC.
Date: 2003-09-08 04:06:47
Message-ID: 28330.1062994007@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

froggle2003(at)yahoo(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Gagan Anand 2003-09-08 04:21:54 bolb data type
Previous Message mathan 2003-09-08 03:42:39 Re: Cannot createdb