PostgreSQL: Unix domain socket vs TCP/IP loopback

2015-05-07 · 1 min read

PostgreSQL will use TCP/IP loopback (if you specify localhost, otherwise if you specify nothing, it will use Unix domain socket.

Unix domain socket are similar to system pipes i.e. they only send data without checksums or other meta information, contrary to TCP/IP sockets that use a three-way handshake; in other words data carried over Unix sockets doesn't have to through the TCP/IP layers; there is also fewer context switches.

Bruce Momjian (a PostgreSQL core developer) made a benchmark which measured query network performance and showing that Unix socket communication was 33% faster than using the TCP/IP stack.

Subscribe to My Newsletter

The latest programming-related news, articles and resources - sent to your inbox monthly. Unsubscribe anytime.