Re: [PERFORM] out of memory problem

2010-11-09 Thread Bob Lunney
gt; Subject: [PERFORM] out of memory problem > To: pgsql-performance@postgresql.org > Date: Tuesday, November 9, 2010, 5:39 AM > Hello together, > > I get an out of memory problem I don't understand. > The installed Postgres-Version is: > PostgreSQL 8.3.7 on i486-pc-linu

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

[PERFORM] out of memory problem

2010-11-09 Thread Till Kirchner
Hello together, I get an out of memory problem I don't understand. The installed Postgres-Version is: PostgreSQL 8.3.7 on i486-pc-linux-gnu, compiled by GCC gcc-4.3.real (Debian 4.3.3-5) 4.3.3 It is running on a 32bit Debian machine with 4GB RAM. Thanks for any help in advance Till -- --

[PERFORM] Out of Memory Problem.

2006-07-12 Thread nicky
Hello Everyone, I'm trying to find out/understand what causes my 'out of memory' error. I do not have enough experience with such logs to understand what is wrong or how to fix it. So i hope someone can point me in the right direction. The 'rpt.rpt_verrichting' table contains about 8.5 milli