From: Tom Lane <[EMAIL PROTECTED]>
Subject: Re: [HACKERS] SO_SNDBUF size is small on win32? 
Date: Tue, 27 Jun 2006 14:43:57 -0400

> >> What I would think might help is a patch on the libpq side (because it
> >> *does* use a nonblocking socket) to avoid sending more than 
> >> 8K per WSASend call.
> > It could definitly be a good idea to have a patch there *as well*, but I
> > think they'd both be affected.
> On the libpq side, sending large messages is probably rare except for
> COPY IN mode.  Has anyone noticed performance issues specifically with

I think libpq interface does not use non-blocking socket. Because
'FRONTEND' symbol is enabled.

  #ifndef FRONTEND
  #define socket(af, type, protocol) pgwin32_socket(af, type, protocol)
  #define accept(s, addr, addrlen) pgwin32_accept(s, addr, addrlen)
  #define connect(s, name, namelen) pgwin32_connect(s, name, namelen)
  #define select(n, r, w, e, timeout) pgwin32_select(n, r, w, e, timeout)
  #define recv(s, buf, len, flags) pgwin32_recv(s, buf, len, flags)
  #define send(s, buf, len, flags) pgwin32_send(s, buf, len, flags)

I think this is only server-side problem. Is this right?


Yoshiyuki Asaba

---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend

Reply via email to