Re: Backend memory growing too much

Andrew Dunstan <andrew@dunslane.net>

From: Andrew Dunstan <andrew@dunslane.net>
To: ohp@pyrenet.fr
Cc: pgsql-hackers list <pgsql-hackers@postgresql.org>
Date: 2007-07-17T15:30:43Z
Lists: pgsql-hackers

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