Re: Postgres using more memory than it should

From: Matthew Wakeling <matthew(at)flymine(dot)org>
To: hubert depesz lubaczewski <depesz(at)depesz(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Postgres using more memory than it should
Date: 2008-12-04 13:06:34
Message-ID: alpine.DEB.1.10.0812041305200.4666@aragorn.flymine.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On Thu, 4 Dec 2008, Matthew Wakeling wrote:
>> http://archives.postgresql.org/pgsql-bugs/2008-11/msg00180.php
>
> Thanks, that does explain everything.

Oh right, yes. It explains everything *except* the fact that the backend
is still holding onto all the RAM after the query is finished. Could the
fact that we SIGINTed it in the middle of the query explain that at all?

Matthew

--
I'd try being be a pessimist, but it probably wouldn't work anyway.

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Rogatzki Rainer 2008-12-04 13:32:44 Trigger function, bad performance
Previous Message Matthew Wakeling 2008-12-04 11:35:49 Re: Postgres using more memory than it should