Re: Memory exhausted in AllocSetAlloc

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "C(dot) Bensend" <benny(at)bennyvision(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Memory exhausted in AllocSetAlloc
Date: 2004-09-12 05:43:09
Message-ID: 12799.1094967789@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

"C. Bensend" <benny(at)bennyvision(dot)com> writes:
> I understand what happened, but not exactly why - this machine is
> running with over 300M of RAM unused. Bumping this value down to 16M
> works fine. But why does it hit a memory exhausted error at 64M?

Maybe it's exceeding a ulimit setting?

You might want to watch it with "top" and see what size the process
actually gets to before failing. I'm not sure how accurate the
vacuum_mem throttle is ...

regards, tom lane

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Andrew Janian 2004-09-12 05:56:32 Database size
Previous Message C. Bensend 2004-09-12 02:41:51 Memory exhausted in AllocSetAlloc