Re: BUG #15033: Segmentation fault running a query - Mailing list pgsql-bugs

From Tom Lane
Subject Re: BUG #15033: Segmentation fault running a query
Date
Msg-id 28887.1517167973@sss.pgh.pa.us
Whole thread Raw
In response to Re: BUG #15033: Segmentation fault running a query  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-bugs
I wrote:
> Andrew Grossman <agrossman@gmail.com> writes:
>> It looks like the same crash:

> Yeah, I agree, create_plan_recurse is at fault there.  Will fix it,
> thanks for confirming!
> Of course, the "fix" will just result in producing a "stack overflowed"
> error instead of dumping core.

I've pushed a fix for that, and also recurse_set_operations which proved
to also be capable of causing a crash at some stack sizes.

> There's still the question of why this
> case worked for you before and doesn't now.  Seemingly, current code
> needs more stack to process this query than 9.5 did.  Is it significantly
> more, or were you just unlucky enough to overrun the limit when you'd
> not quite done so before?  And if it is significantly more, is there
> anything we can reasonably do about that?  These questions remain unclear
> at this point.

It seems that the direct cause of the change is that we now generate a
Path representation of a setop tree, where we didn't before.  The Path
representation is much deeper than the setop tree --- about three
nested Path nodes per setop step --- and it's the deeper recursion
involved in processing that that causes the extra stack demand.
So I'm afraid there's little to be done about it.

On the bright side, I find that with sufficient stack, current code runs
this query in about 4 seconds where 9.5 took 95 seconds.  Seems to be
thanks to commit 25c539233 ("Improve performance in freeing memory
contexts").

            regards, tom lane


pgsql-bugs by date:

Previous
From: Devrim Gündüz
Date:
Subject: Re: BUG #15018: yum install postgis24_96 failure
Next
From: Tom Lane
Date:
Subject: Re: BUG #15025: PSQL CLI - inconsistency when both -d and -U supplies a username