Re: Backend memory growing too much - Mailing list pgsql-hackers

From Andrew Dunstan
Subject Re: Backend memory growing too much
Date
Msg-id 469CE0A3.5020000@dunslane.net
Whole thread Raw
In response to Backend memory growing too much  (ohp@pyrenet.fr)
Responses Re: Backend memory growing too much  (ohp@pyrenet.fr)
List 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


pgsql-hackers by date:

Previous
From: Zdenek Kotala
Date:
Subject: Re: compiler warnings on the buildfarm
Next
From: Tom Lane
Date:
Subject: Re: write_pipe_chunks patch messes up early error message output