Re: BUG #2305: "No bufferspace available" error on large insert - Mailing list pgsql-bugs

From John R Pierce
Subject Re: BUG #2305: "No bufferspace available" error on large insert
Date
Msg-id 440F400D.9020907@hogranch.com
Whole thread Raw
In response to BUG #2305: "No bufferspace available" error on large insert  ("H. Guijt" <hg@terma.com>)
List pgsql-bugs
...
> 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 ?

pgsql-bugs by date:

Previous
From: Michael Fuhr
Date:
Subject: Re: BUG #2306: Duplicate primary key
Next
From: Tom Lane
Date:
Subject: Re: BUG #2308: pg_dump -a does not respect referential dependencies