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

Поиск
Список
Период
Сортировка
От John R Pierce
Тема Re: BUG #2305: "No bufferspace available" error on large insert
Дата
Msg-id 440F400D.9020907@hogranch.com
обсуждение исходный текст
Ответ на BUG #2305: "No bufferspace available" error on large insert  ("H. Guijt" <hg@terma.com>)
Список 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 по дате отправления:

Предыдущее
От: Michael Fuhr
Дата:
Сообщение: Re: BUG #2306: Duplicate primary key
Следующее
От: Tom Lane
Дата:
Сообщение: Re: BUG #2308: pg_dump -a does not respect referential dependencies