Re: SO_SNDBUF size is small on win32? - Mailing list pgsql-hackers

From Yoshiyuki Asaba
Subject Re: SO_SNDBUF size is small on win32?
Date
Msg-id 20060628.013348.74730394.y-asaba@sraoss.co.jp
Whole thread Raw
In response to Re: SO_SNDBUF size is small on win32?  (Martijn van Oosterhout <kleptog@svana.org>)
List pgsql-hackers
From: Martijn van Oosterhout <kleptog@svana.org>
Subject: Re: [HACKERS] SO_SNDBUF size is small on win32?
Date: Tue, 27 Jun 2006 18:13:18 +0200

> On Tue, Jun 27, 2006 at 11:45:53AM -0400, Andrew Dunstan wrote:
> > No, it says it occurs if this condition is met: "A single *send* call or 
> > *WSASend* call fills the whole underlying socket send buffer."
> > 
> > This will surely be true if the buffer sizes are the same. They 
> > recommend making the socket buffer at least 1 byte bigger.
> 
> Ok, but even then, are there any benchmarks to show it makes a
> difference. The articles suggests there should be but it would be nice
> to see how much difference it makes...

I see the problem in this environment.

* client - Windows XP - using ODBC driver

* server - Windows XP - 8.1.4

* query time - original -> about 12sec. - patch version -> about 3sec.

However, this problem did not occur when I changed a client
machine...

Regards,
--
Yoshiyuki Asaba
y-asaba@sraoss.co.jp


pgsql-hackers by date:

Previous
From: "Jim C. Nasby"
Date:
Subject: Re: vacuum, performance, and MVCC
Next
From: "Jim C. Nasby"
Date:
Subject: Re: Table clustering idea