Re: BUG #2305: "No bufferspace available" error on large insert

>> Upon issuing the insert statement I receive the following error message:
>> "could not send data to server: No buffer space available
>> (0x00002747/10055)"
>>
>> I suspect that this happens because we are inserting a lot of data: the
>> first BYTEA column is about 1.8MB, while the second is about 0.5MB.
>> However...
>>
>> - The same operation completes without problems when running on other
>> machines (which are all running Windows XP and the same Postgres
>> version).
> ...
>
> are the various tuning parameters in $PGDATA/postgresql.conf set the same
> on these various systems ?

Yes. We haven't touched these parameters; all the copies of Postgres are
installed with their default parameters.

I have also been able to try the same operation on another Windows 2000
machine and it completed without problems, so we know it isn't the OS perse.

Regards,

Hans Guijt

TERMA B.V.
Schuttersveld 9
NL-2316 XG, Leiden
The Netherlands
Phone: +31 (0)71 52 40 835
Telefax: +31 (0)71 51 43 277
E-mail: hg(at)terma(dot)com