Re: [PERFORM] out of memory problem

2010-11-09 Thread Bob Lunney
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: [

Re: [PERFORM] out of memory problem

2010-11-09 Thread Tom Lane
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