Re: No buffer space available - Mailing list pgsql-general

From Martijn van Oosterhout
Subject Re: No buffer space available
Date
Msg-id 20070307064616.GA1482@svana.org
Whole thread Raw
In response to Re: No buffer space available  (andyk <andyk@commandprompt.com>)
Responses Re: No buffer space available
List pgsql-general
On Tue, Mar 06, 2007 at 08:38:22PM +0200, andyk wrote:
>    This error is returned by libpq, as a reaction on WSANOBUFS error
> from Windows Socket System. This means, applications tries to send much
> data, and system can't do it the same quickly. Possible, libpq should
> handle this error more carefully, and wait until all data will be send
> to the server.

That's bizarre. If libpq is sending data too fast then the socket
library should block. The only possible thing lbpq can do is send it
again, which will just give the same error... busy loop. This is a
problem the socket library should handle for you.

Incidently, according to this page:

http://www.dispi.com/proxyplus/faq/articles/EN/art10002.htm

The error relates to too many sockets, rather than out of memory. In
which case libpq really can't do anything about it.

Have a nice day,
--
Martijn van Oosterhout   <kleptog@svana.org>   http://svana.org/kleptog/
> From each according to his ability. To each according to his ability to litigate.

Attachment

pgsql-general by date:

Previous
From: Bruno Wolff III
Date:
Subject: Re: Can I getting a unique ID from a select
Next
From: Peter Eisentraut
Date:
Subject: Re: vacuum error