Skip site navigation (1) Skip section navigation (2)

Re: Patch for SPI subtransaction memory leakage

From: "Simon Riggs" <simon(at)2ndquadrant(dot)com>
To: "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: <pgsql-patches(at)postgreSQL(dot)org>
Subject: Re: Patch for SPI subtransaction memory leakage
Date: 2006-11-09 08:59:07
Message-ID: 1163062747.3634.219.camel@silverbirch.site (view raw or flat)
Thread:
Lists: 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



In response to

Responses

pgsql-patches by date

Next:From: Tom LaneDate: 2006-11-09 14:19:31
Subject: Re: Patch for SPI subtransaction memory leakage
Previous:From: Brendan JurdDate: 2006-11-09 01:19:59
Subject: Re: [GENERAL] ISO week dates

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group