Re: 9.0 Out of memory - Mailing list pgsql-general

From Tom Lane
Subject Re: 9.0 Out of memory
Date
Msg-id 25719.1302670915@sss.pgh.pa.us
Whole thread Raw
In response to 9.0 Out of memory  (Jeremy Palmer <JPalmer@linz.govt.nz>)
List pgsql-general
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

pgsql-general by date:

Previous
From: Carlo Stonebanks
Date:
Subject: Re: Revisiting UPDATE FROM ... ORDER BY not respected
Next
From: Tom Lane
Date:
Subject: Re: [BUGS] PostgreSQL backend process high memory usage issue