Re: Performance: Unix sockets vs. TCP/IP sockets - Mailing list pgsql-general

From Frank Joerdens
Subject Re: Performance: Unix sockets vs. TCP/IP sockets
Date
Msg-id 20010126170710.B19363@rakete.joerdens.de
Whole thread Raw
In response to Re: Performance: Unix sockets vs. TCP/IP sockets  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
On Thu, Jan 25, 2001 at 11:07:19PM -0500, Tom Lane wrote:
> Frank Joerdens <frank@joerdens.de> writes:
> > What performance penalty can I expect when going over TCP/IP sockets
> > instead of Unix sockets?
>
> On a properly designed kernel, there shouldn't be any measurable
> performance difference between a local TCP connection and a Unix-socket
> connection.

Ah. That's good hear. I'd heard that TCP/IP was _significantly_ slower
than Unix sockets. But maybe that was just Linux.

>
> There are not-so-well-designed kernels out there, but I forget which
> they are (and you didn't bother to specify your platform anyway).

It's Solaris 7 (cf. the current thread in hackers).

>
> If you want a reliable answer, fire up a data-transfer-intensive task,
> say a COPY OUT of a large table, and time it both ways.

I might try that in a couple of weeks' time when the current rush is over.

Ta, Frank

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Re: Load a database into memory
Next
From: Alfonso Peniche
Date:
Subject: Problem with inheritance