Re: out of memory error

From: Geoffrey Myers <geof(at)serioustechnology(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: out of memory error
Date: 2011-07-05 12:12:21
Message-ID: 4E12FFA5.30401@serioustechnology.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Craig Ringer wrote:
> On 3/07/2011 6:00 PM, Geoffrey Myers wrote:
>
>> out of memory for query result
>>
>> How is this possible?
>
> Resource limits?

Could this message be generated because of shared memory issues?

The odd thing is the error was generated by a user process, but there is
no reference to the error in the database log file.

> Do you have a ulimit in place that applies to postgresql? You can check
> by examining the resource limits of a running postgresql backend as
> shown in /proc/$PG_PID where $PG_PID is the process ID of the backend of
> interest.
>
> Check your work_mem in postgresql.conf, too.

work_mem is commented out on both machines, so I suspect that it is then
using the default value? What would be the default value?

>
> --
> Craig Ringer
>

--
Geoffrey Myers
Myers Consulting Inc.
770.592.1651

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Geoffrey Myers 2011-07-05 12:36:09 Re: out of memory error
Previous Message Geoffrey Myers 2011-07-05 12:05:16 Re: out of memory error