Re: out of memory problem

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Till Kirchner <till(dot)kirchner(at)vti(dot)bund(dot)de>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: out of memory problem
Date: 2010-11-09 15:22:33
Message-ID: 17966.1289316153@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Till Kirchner <till(dot)kirchner(at)vti(dot)bund(dot)de> 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 query that is known to cause
that sort of thing, so I'm guessing that the leak is being caused by
the postgis functions you're using. You might ask about this on the
postgis lists.

regards, tom lane

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Bob Lunney 2010-11-09 16:02:42 Re: out of memory problem
Previous Message Till Kirchner 2010-11-09 10:39:48 out of memory problem