Quick Links

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
Views:	Whole Thread \| Raw Message \| Download mbox \| Resend email
Thread:
Lists:	pgsql-hackers pgsql-patches

Hi,

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

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

Attachment	Content-Type	Size
unknown_filename	text/plain	757 bytes

Re: SO_SNDBUF size is small on win32? at 2006-06-27 15:30:56 from Tom Lane
Re: SO_SNDBUF size is small on win32? at 2006-06-27 15:31:20 from Martijn van Oosterhout
Re: SO_SNDBUF size is small on win32? at 2006-06-27 18:49:58 from Mark Woodward
Re: [HACKERS] SO_SNDBUF size is small on win32? at 2006-08-11 20:44:23 from Bruce Momjian

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

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