Re: Memory leak in PL/pgSQL function which CREATE/SELECT/DROP a temporary table

Поиск
Список
Период
Сортировка
От Heikki Linnakangas
Тема Re: Memory leak in PL/pgSQL function which CREATE/SELECT/DROP a temporary table
Дата
Msg-id 51C0572C.5080708@vmware.com
обсуждение исходный текст
Ответ на Memory leak in PL/pgSQL function which CREATE/SELECT/DROP a temporary table  ("MauMau" <maumau307@gmail.com>)
Ответы Re: Memory leak in PL/pgSQL function which CREATE/SELECT/DROP a temporary table
Список pgsql-hackers
On 18.06.2013 14:27, MauMau wrote:
> The cause of the memory increase appears to be CacheMemoryContext. When
> I attached to postgres with gdb and ran "call
> MemoryContextStats(TopMemoryContext)" several times, the size of
> CacheMemoryContext kept increasing.

Hmm. I could repeat this, and it seems that the catcache for 
pg_statistic accumulates negative cache entries. Those slowly take up 
the memory.

Seems that we should somehow flush those, when the table is dropped. Not 
sure how, but I'll take a look.

- Heikki



В списке pgsql-hackers по дате отправления:

Предыдущее
От: "Etsuro Fujita"
Дата:
Сообщение: Re: Patch for removng unused targets
Следующее
От: Andres Freund
Дата:
Сообщение: Re: Support for REINDEX CONCURRENTLY