Backend memory growing too much

Поиск
Список
Период
Сортировка
От ohp@pyrenet.fr
Тема Backend memory growing too much
Дата
Msg-id Pine.UW2.4.53.0707171513010.25967@sun.pyrenet
обсуждение исходный текст
Ответы Re: Backend memory growing too much
Re: Backend memory growing too much
Список pgsql-hackers
Hi everyone,

I've been using sqlgrey for some time now and I'm very surprised by the
memory taken by the backends to which sqlgrey is connected.

look at process 4111 and 28108 . They roughly take twice the space the
other backend take.

Could there be a memory leak?

I don't know much about DBI/DBD but I know sqlgrey uses a lot of
prepare/prepare_cached statements.

What could cause?

shared_buffer is 400MB here.

TIA

-- 
Olivier PRENANT                    Tel: +33-5-61-50-97-00 (Work)
15, Chemin des Monges                +33-5-61-50-97-01 (Fax)
31190 AUTERIVE                       +33-6-07-63-80-64 (GSM)
FRANCE                          Email: ohp@pyrenet.fr
------------------------------------------------------------------------------
Make your life a dream, make your dream a reality. (St Exupery)

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Earlier suggestion to get gcov to work by adding $(CFLAGS) to module link line
Следующее
От: "Brendan Jurd"
Дата:
Сообщение: Re: Invalid to_date patterns (was: [PATCHES] [GENERAL] ISO week dates)