Re: OOM on EXPLAIN with lots of nodes - Mailing list pgsql-hackers

From Alexey Bashtanov
Subject Re: OOM on EXPLAIN with lots of nodes
Date
Msg-id 54B52AAA.20703@imap.cc
Whole thread Raw
In response to Re: OOM on EXPLAIN with lots of nodes  (Heikki Linnakangas <hlinnakangas@vmware.com>)
List pgsql-hackers
On 13.01.2015 16:47, Heikki Linnakangas wrote:
> Hmm, something like the attached? Seems reasonable...
>
> - Heikki
>
yes, i have tested something like this, it stopped eating memory

Just one small notice to the patch you attached: maybe it would be more 
safe to switch to oldcxt before calling 
ExplainPropertyText/ExplainPropertyList?
Otherwise are you pretty sure ExplainPropertyText and 
ExplainPropertyList are not going perform any pallocs without immediate 
pfrees in current memory context even in future?

Regards,  Alexey Bashtanov




pgsql-hackers by date:

Previous
From: Dean Rasheed
Date:
Subject: Re: WITH CHECK and Column-Level Privileges
Next
From: Andres Freund
Date:
Subject: authentication_timeout ineffective for replication connections