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.
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? |