Re: out of memory error

On 3/07/2011 6:00 PM, Geoffrey Myers wrote:

> out of memory for query result
>
> How is this possible?

Resource limits?

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.

--
Craig Ringer