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

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Performance: Unix sockets vs. TCP/IP sockets
Дата
Msg-id 28501.980482039@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Performance: Unix sockets vs. TCP/IP sockets  (Frank Joerdens <frank@joerdens.de>)
Ответы Re: Performance: Unix sockets vs. TCP/IP sockets  (Frank Joerdens <frank@joerdens.de>)
Список 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 по дате отправления:

Предыдущее
От: Kyle
Дата:
Сообщение: DBD::Pg using int2 / smallint
Следующее
От: Tom Lane
Дата:
Сообщение: Re: PL/PySQL?