Re: 9.0 Out of memory

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Jeremy Palmer <JPalmer(at)linz(dot)govt(dot)nz>
Cc: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Re: 9.0 Out of memory
Date: 2011-04-13 05:01:55
Message-ID: 25719.1302670915@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Jeremy Palmer <JPalmer(at)linz(dot)govt(dot)nz> writes:
> I running PostgreSQL 9.0.3 and getting an out of memory error while running a big transaction. This error does not crash the 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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2011-04-13 05:29:43 Re: [GENERAL] PostgreSQL backend process high memory usage issue
Previous Message Carlo Stonebanks 2011-04-13 04:10:54 Re: Revisiting UPDATE FROM ... ORDER BY not respected