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