Hi
On a large transaction involving an insert of 8 million rows, after a
while Postgres complains of an out of memory error.
Failed on request of size 32
I get no other message.
Shmmax is set to 1 Gb
Shared_buffers set to 50000
Max memory on box is 4Gb..Postgres is the only major application running
other than a jvm with minimal heap.
Other than breaking this transaction into smaller bits(which may not be
possible as this scenario is not encountered often), am I missing
something.
Sriram