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: [EMAIL PROTECTED]
---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings
