From: | ohp(at)pyrenet(dot)fr |
---|---|
To: | pgsql-hackers list <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Backend memory growing too much |
Date: | 2007-07-17 13:19:29 |
Message-ID: | Pine.UW2.4.53.0707171513010.25967@sun.pyrenet |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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(at)pyrenet(dot)fr
------------------------------------------------------------------------------
Make your life a dream, make your dream a reality. (St Exupery)
Attachment | Content-Type | Size |
---|---|---|
ps | text/plain | 1.7 KB |
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2007-07-17 13:27:46 | Re: plpgsql FOR loop doesn't guard against strange step values |
Previous Message | Zeugswetter Andreas ADI SD | 2007-07-17 10:00:30 | Re: Straightforward changes for increased SMP scalability |