Re: PostgreSQL (9.3 and 9.6) eats all memory when using many tables - Mailing list pgsql-bugs

From hubert depesz lubaczewski
Subject Re: PostgreSQL (9.3 and 9.6) eats all memory when using many tables
Date
Msg-id 20160613133905.GA16492@depesz.com
Whole thread Raw
In response to Re: PostgreSQL (9.3 and 9.6) eats all memory when using many tables  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-bugs
On Mon, Jun 13, 2016 at 09:36:32AM -0400, Tom Lane wrote:
> Another problem, if the bloat is being driven by explicit PREPARE commands
> as you illustrate here, is that the backend doesn't get to silently

I did the same test with
$dbh->{pg_server_prepare} = 0;
(in pg logs, it changes logged lines from:
prepare <unnamed>:...
bind <unnamed>:...
execute <unnamed>:...
into:
statement:...

afterwards memory problems seemed to be the same.

Best regards,

depesz

--
The best thing about modern society is how easy it is to avoid contact with it.
                                                             http://depesz.com/

pgsql-bugs by date:

Previous
From: Tom Lane
Date:
Subject: Re: PostgreSQL (9.3 and 9.6) eats all memory when using many tables
Next
From: Jeff Janes
Date:
Subject: Re: PostgreSQL (9.3 and 9.6) eats all memory when using many tables