Backend memory growing too much - Mailing list pgsql-hackers

From ohp@pyrenet.fr
Subject Backend memory growing too much
Date
Msg-id Pine.UW2.4.53.0707171513010.25967@sun.pyrenet
Whole thread Raw
Responses Re: Backend memory growing too much  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: Backend memory growing too much  (Andrew Dunstan <andrew@dunslane.net>)
List 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 by date:

Previous
From: Tom Lane
Date:
Subject: Re: Earlier suggestion to get gcov to work by adding $(CFLAGS) to module link line
Next
From: "Brendan Jurd"
Date:
Subject: Re: Invalid to_date patterns (was: [PATCHES] [GENERAL] ISO week dates)