Skip site navigation (1) Skip section navigation (2)

SO_SNDBUF size is small on win32?

From: Yoshiyuki Asaba <y-asaba(at)sraoss(dot)co(dot)jp>
To: pgsql-hackers(at)postgresql(dot)org
Subject: SO_SNDBUF size is small on win32?
Date: 2006-06-27 15:23:13
Message-ID: 20060628.002313.74731148.y-asaba@sraoss.co.jp (view raw or flat)
Thread:
Lists: pgsql-hackerspgsql-patches
Hi,

I see a performance issue on win32. This problem is causes by the
following URL. 

http://support.microsoft.com/kb/823764/EN-US/

On win32, default SO_SNDBUF value is 8192 bytes. And libpq's buffer is
8192 too.

pqcomm.c:117
  #define PQ_BUFFER_SIZE 8192

send() may take as long as 200ms. So, I think we should increase
SO_SNDBUF to more than 8192. I attache the patch.

Regards,
--
Yoshiyuki Asaba
y-asaba(at)sraoss(dot)co(dot)jp

Responses

pgsql-hackers by date

Next:From: Tom LaneDate: 2006-06-27 15:30:56
Subject: Re: SO_SNDBUF size is small on win32?
Previous:From: Tom LaneDate: 2006-06-27 15:15:47
Subject: Re: [COMMITTERS] pgsql: Disallow changing/dropping default expression

pgsql-patches by date

Next:From: Tom LaneDate: 2006-06-27 15:30:56
Subject: Re: SO_SNDBUF size is small on win32?
Previous:From: Tom LaneDate: 2006-06-27 13:58:02
Subject: Re: [PATCHES] Non-transactional pg_class, try 2

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group