Be sure that you are starting PostgreSQL using an account with sufficient
memory limits:
ulimit -m
If the account has memory limit below the server's configuration you may get
the out of memory error.
Bob Lunney
--- On Tue, 11/9/10, Till Kirchner wrote:
> From: Till Kirchner
> Subject: [
Till Kirchner writes:
> I get an out of memory problem I don't understand.
It's pretty clear that something is leaking memory in the per-query
context:
>ExecutorState: 1833967692 total in 230 blocks; 9008 free (3
> chunks); 1833958684 used
There doesn't seem to be anything in your quer