Hi Andrew
On Tue, 17 Jul 2007, Andrew Dunstan wrote:
> Date: Tue, 17 Jul 2007 11:30:43 -0400
> From: Andrew Dunstan <[EMAIL PROTECTED]>
> To: [EMAIL PROTECTED]
> Cc: pgsql-hackers list
> Subject: Re: [HACKERS] Backend memory growing too much
>
>
>
> [EMAIL PROTE
[EMAIL PROTECTED] 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
[EMAIL PROTECTED] writes:
> I don't know much about DBI/DBD but I know sqlgrey uses a lot of
> prepare/prepare_cached statements.
Well, those aren't exactly free.
Possibly you could learn something about it by attaching to one of
these backends with gdb and executing
call MemoryContextSt
