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

From Tom Lane
Subject Re: Performance: Unix sockets vs. TCP/IP sockets
Date
Msg-id 28501.980482039@sss.pgh.pa.us
Whole thread Raw
In response to Performance: Unix sockets vs. TCP/IP sockets  (Frank Joerdens <frank@joerdens.de>)
Responses Re: Performance: Unix sockets vs. TCP/IP sockets  (Frank Joerdens <frank@joerdens.de>)
List pgsql-general
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.

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).

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.

            regards, tom lane

pgsql-general by date:

Previous
From: Kyle
Date:
Subject: DBD::Pg using int2 / smallint
Next
From: Tom Lane
Date:
Subject: Re: PL/PySQL?