Skip site navigation (1) Skip section navigation (2)

Peripheral Links

Header And Logo

PostgreSQL
| The world's most advanced open source database.

Site Navigation

Search archives
  Advanced Search

Re: Performance: Unix sockets vs. TCP/IP sockets


  • From: Tom Lane <tgl@sss.pgh.pa.us>
  • To: Frank Joerdens <frank@joerdens.de>
  • Cc: pgsql-general@postgresql.org
  • Subject: Re: Performance: Unix sockets vs. TCP/IP sockets
  • Date: Thu, 25 Jan 2001 23:07:19 -0500
  • Message-id: <28501.980482039@sss.pgh.pa.us>

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



Home | Main Index | Thread Index

Privacy Policy | PostgreSQL Archives hosted by Command Prompt, Inc. | Designed by tinysofa
Copyright © 1996 – 2008 PostgreSQL Global Development Group