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