Re: Low throughput of binary inserts from windows to linux - Mailing list pgsql-performance

From David Boreham
Subject Re: Low throughput of binary inserts from windows to linux
Date
Msg-id 457EDF22.4010303@boreham.org
Whole thread Raw
In response to Re: Low throughput of binary inserts from windows to linux  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-performance
Tom Lane wrote:
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. 
Last time I did battle with nagle/delayed ack interaction in windows (the other end
has to be another stack implementation -- windows to itself I don't think has the problem),
it _did_ honor TCP_NODELAY. That was a while ago (1997) but I'd be surprised
if things have changed much since then.

Basically nagle has to be turned off for protocols like this (request/response interaction
over TCP) otherwise you'll sometimes end up with stalls waiting for the delayed ack
before sending, which in turn results in very low throughput, per connection. As I remember
Windows client talking to Solaris server had the problem, but various other permutations
of client and server stack implementation did not.





pgsql-performance by date:

Previous
From: Greg Smith
Date:
Subject: Re: New to PostgreSQL, performance considerations
Next
From: "Daniel van Ham Colchete"
Date:
Subject: Re: New to PostgreSQL, performance considerations