Re: No buffer space available

From: Martijn van Oosterhout <kleptog(at)svana(dot)org>
To: andyk <andyk(at)commandprompt(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: No buffer space available
Date: 2007-03-07 06:46:16
Message-ID: 20070307064616.GA1482@svana.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)svana(dot)org> http://svana.org/kleptog/
> From each according to his ability. To each according to his ability to litigate.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Peter Eisentraut 2007-03-07 06:52:55 Re: vacuum error
Previous Message Reuven M. Lerner 2007-03-07 06:12:20 Re: Database slowness -- my design, hardware, or both?