Re: 9.0 Out of memory

Jeremy Palmer <JPalmer@linz.govt.nz> writes:
> I running PostgreSQL 9.0.3 and getting an out of memory error while running a big transaction. This error does not
crashthe backend.  

If it's a standard "out of memory" message, there should be a memory
context map dumped to postmaster's stderr.  (Which is inconvenient for
some logging arrangements, but it's hard to improve that without risking
not being able to print the map for lack of memory ...)  If you could
show us the map it might help to figure out what's happening.

            regards, tom lane