Re: Patch for SPI subtransaction memory leakage - Mailing list pgsql-patches

From Simon Riggs
Subject Re: Patch for SPI subtransaction memory leakage
Date
Msg-id 1163062747.3634.219.camel@silverbirch.site
Whole thread Raw
In response to Patch for SPI subtransaction memory leakage  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Patch for SPI subtransaction memory leakage
List pgsql-patches
On Fri, 2006-11-03 at 00:40 -0500, Tom Lane wrote:
> I noticed a gripe about plpgsql exceptions leaking memory:
> http://archives.postgresql.org/pgsql-performance/2006-11/msg00032.php
> (woulda been nice if he'd reported it more formally, but whatever.)
>
> Some experimentation shows that there is indeed an issue, eg this
> function leaks about 16K per iteration in HEAD:

So at 10,000 tpm that leaks a GB of RAM every 7 minutes. I'm surprised
we've not had that reported before; wow!

This is still a live request for more input, yes?

Not sure if you got back to the OP on this point, but I'd suggest
raising this on -perform to get more feedback.

--
  Simon Riggs
  EnterpriseDB   http://www.enterprisedb.com



pgsql-patches by date:

Previous
From: "Brendan Jurd"
Date:
Subject: Re: [GENERAL] ISO week dates
Next
From: Tom Lane
Date:
Subject: Re: Patch for SPI subtransaction memory leakage