Re: 8.3rc1 Out of memory when performing update - Mailing list pgsql-performance

From Guillaume Smet
Subject Re: 8.3rc1 Out of memory when performing update
Date
Msg-id 1d4e0c10801280018x17103cc8o7ead9fdc75d69470@mail.gmail.com
Whole thread Raw
In response to Re: 8.3rc1 Out of memory when performing update  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-performance
On Jan 25, 2008 5:50 AM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
> Hmm.  I think what that really means is you haven't got to the part of
> the query where the leak is :-(.  In my attempt to reproduce this
> I found that 8.3 has introduced a memory leak into the RI trigger
> support, such that even if an UPDATE doesn't change the FK columns
> it's still likely to leak a few dozen bytes per updated row.
>
> Please see if the attached patch makes it better for you.

Just FYI, somebody on #postgresql had the exact same problem of
memleaks during update yesterday and your patch fixed it for him too.

--
Guillaume

pgsql-performance by date:

Previous
From: "Tory M Blue"
Date:
Subject: Re: Postgres 8.2 memory weirdness
Next
From: Matthew Lunnon
Date:
Subject: Performance issues migrating from 743 to 826