Re: Backend memory growing too much

From: Andrew Dunstan <andrew(at)dunslane(dot)net>
To: ohp(at)pyrenet(dot)fr
Cc: pgsql-hackers list <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Backend memory growing too much
Date: 2007-07-17 15:30:43
Message-ID: 469CE0A3.5020000@dunslane.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

ohp(at)pyrenet(dot)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

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2007-07-17 15:30:52 Re: write_pipe_chunks patch messes up early error message output
Previous Message Andrew Dunstan 2007-07-17 15:25:52 Re: write_pipe_chunks patch messes up early error message output