Re: Memory Errors...

From: Karel Zak <zakkr(at)zf(dot)jcu(dot)cz>
To: Ian Harding <ianh(at)tpchd(dot)org>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Memory Errors...
Date: 2002-09-19 14:22:59
Message-ID: 20020919162259.F23671@zf.jcu.cz
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Thu, Sep 19, 2002 at 07:10:50AM -0700, Ian Harding wrote:
> Can someone tell me what these mean? They happen when running big ugly pgtcl functions that delete, insert and update lots of stuff in the database.
>
> ERROR: Memory exhausted in AllocSetContextCreate(8192)
> ERROR: Memory exhausted in AllocSetAlloc(88)
> ERROR: Memory exhausted in AllocSetAlloc(60)

This means libc call malloc() returns NULL instead allocated memory.

I think some PostgreSQL memory setting limits have not effect for this,
because it's standard memory and not shared or so.

You need more RAM or less expensive SQL questions :-)

Karel

--
Karel Zak <zakkr(at)zf(dot)jcu(dot)cz>
http://home.zf.jcu.cz/~zakkr/

C, PostgreSQL, PHP, WWW, http://docs.linux.cz, http://mape.jcu.cz

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2002-09-19 14:38:39 Re: NUMERIC and arithmetics
Previous Message Andrew Sullivan 2002-09-19 14:22:42 Re: I'm using it!