Re: 8.3rc1 Out of memory when performing update

Поиск
Список
Период
Сортировка
От Guillaume Smet
Тема Re: 8.3rc1 Out of memory when performing update
Дата
Msg-id 1d4e0c10801280018x17103cc8o7ead9fdc75d69470@mail.gmail.com
обсуждение исходный текст
Ответ на Re: 8.3rc1 Out of memory when performing update  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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 по дате отправления:

Предыдущее
От: "Tory M Blue"
Дата:
Сообщение: Re: Postgres 8.2 memory weirdness
Следующее
От: Matthew Lunnon
Дата:
Сообщение: Performance issues migrating from 743 to 826