Re: BUG #2305: "No bufferspace available" error on large insert
От | Hans Guijt |
---|---|
Тема | Re: BUG #2305: "No bufferspace available" error on large insert |
Дата | |
Msg-id | 001a01c64389$d740b340$ab14010a@nlpc17 обсуждение исходный текст |
Ответ на | 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 ? 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@terma.com
В списке pgsql-bugs по дате отправления: