Hi Andrew On Tue, 17 Jul 2007, Andrew Dunstan wrote: > Date: Tue, 17 Jul 2007 11:30:43 -0400 > From: Andrew Dunstan <[EMAIL PROTECTED]> > To: [EMAIL PROTECTED] > Cc: pgsql-hackers list <pgsql-hackers@postgresql.org> > Subject: Re: [HACKERS] Backend memory growing too much > > > > [EMAIL PROTECTED] wrote: > > > > I don't know much about DBI/DBD but I know sqlgrey uses a lot of > > prepare/prepare_cached statements. > > > > > > You can inhibit DBD::Pg from using server side prepares if you need to, > by executing: > > $dbh->{pg_server_prepare} = 0; > > (as documented in the excellent DBD::Pg docs). > > cheers > > andrew > Thanks! That made the trick! I assume this is because sqlgrey prepares statements (always the same) and neither finish them.
Best regards -- 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: [EMAIL PROTECTED] ------------------------------------------------------------------------------ Make your life a dream, make your dream a reality. (St Exupery) ---------------------------(end of broadcast)--------------------------- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq