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

From: John R Pierce <pierce(at)hogranch(dot)com>
To: "H(dot) Guijt" <hg(at)terma(dot)com>, pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #2305: "No bufferspace available" error on large insert
Date: 2006-03-08 20:35:25
Message-ID: 440F400D.9020907@hogranch.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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 ?

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2006-03-08 21:01:30 Re: BUG #2308: pg_dump -a does not respect referential dependencies
Previous Message Michael Fuhr 2006-03-08 20:30:37 Re: BUG #2306: Duplicate primary key