Re: Low throughput of binary inserts from windows to linux

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Low throughput of binary inserts from windows to linux
Дата
Msg-id 4101.1165941200@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Low throughput of binary inserts from windows to linux  ("Axel Waggershauser" <awagger@web.de>)
Ответы Re: Low throughput of binary inserts from windows to linux
Список pgsql-performance
"Axel Waggershauser" <awagger@web.de> writes:
> On 12/12/06, Tom Lane <tgl@sss.pgh.pa.us> wrote:
>> I think this almost certainly indicates a Nagle/delayed-ACK
>> interaction.  I googled and found a nice description of the issue:
>> http://www.stuartcheshire.org/papers/NagleDelayedAck/

> In case I was mistaken, this explanation makes perfectly sens to me.
> But then again it would indicate a 'bug' in libpq, in the sense that
> it (apparently) sets TCP_NODELAY on linux but not on windows.

No, it would mean a bug in Windows in that it fails to honor TCP_NODELAY.
Again, given that you only see the behavior at one specific message
length, I suspect this is a corner case rather than a generic "it
doesn't work" issue.

We're pretty much guessing though.  Have you tried tracing the traffic
with a packet sniffer to see what's really happening at different
message sizes?

            regards, tom lane

В списке pgsql-performance по дате отправления:

Предыдущее
От: Alvaro Herrera
Дата:
Сообщение: Re: New to PostgreSQL, performance considerations
Следующее
От: Greg Smith
Дата:
Сообщение: Re: New to PostgreSQL, performance considerations