Re: OOM on EXPLAIN with lots of nodes

From: Alexey Bashtanov <bashtanov(at)imap(dot)cc>
To: Heikki Linnakangas <hlinnakangas(at)vmware(dot)com>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: OOM on EXPLAIN with lots of nodes
Date: 2015-01-13 14:24:42
Message-ID: 54B52AAA.20703@imap.cc
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Andres Freund 2015-01-13 14:29:04 authentication_timeout ineffective for replication connections
Previous Message Dean Rasheed 2015-01-13 14:09:14 Re: WITH CHECK and Column-Level Privileges