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

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Re: Load a database into memory
Следующее
От: Alfonso Peniche
Дата:
Сообщение: Problem with inheritance