Re: Backend memory growing too much
От | ohp@pyrenet.fr |
---|---|
Тема | Re: Backend memory growing too much |
Дата | |
Msg-id | Pine.UW2.4.53.0707210938350.23089@sun.pyrenet обсуждение исходный текст |
Ответ на | Re: Backend memory growing too much (Andrew Dunstan <andrew@dunslane.net>) |
Список | pgsql-hackers |
Hi Andrew On Tue, 17 Jul 2007, Andrew Dunstan wrote: > Date: Tue, 17 Jul 2007 11:30:43 -0400 > From: Andrew Dunstan <andrew@dunslane.net> > To: ohp@pyrenet.fr > Cc: pgsql-hackers list <pgsql-hackers@postgresql.org> > Subject: Re: [HACKERS] Backend memory growing too much > > > > ohp@pyrenet.fr 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: ohp@pyrenet.fr ------------------------------------------------------------------------------ Make your life a dream, make your dream a reality. (St Exupery)
В списке pgsql-hackers по дате отправления: