Re: BUG #11811: Server segfault with many subpartitions when using nestloop - Mailing list pgsql-bugs

From Michael Paquier
Subject Re: BUG #11811: Server segfault with many subpartitions when using nestloop
Date
Msg-id CAB7nPqTwVOOLFw0EEJeK8Lb65nd-xzcB-=WM5NO-6Ng=+cOj1Q@mail.gmail.com
Whole thread Raw
In response to Re: BUG #11811: Server segfault with many subpartitions when using nestloop  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: BUG #11811: Server segfault with many subpartitions when using nestloop  (Federico Campoli <federico@brandwatch.com>)
List pgsql-bugs
On Wed, Oct 29, 2014 at 3:00 AM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
> federico@brandwatch.com writes:
>> We noticed a server crash with SEGFAULT after the upgrade to 9.2.9 with the
>> queries involving a large number of sub partitions.
>
> Hm.  The given test case works fine for me in 9.2 branch tip.  I wonder
> whether commit 71b88cf52e3baccf6be77709fece5837ef04ea20 fixed it.
Some bisecting later... Yes that's fixed with 71b88cf. This fix will
show up in the next minor releases 9.2.10, 9.3.6 etc. You came up with
a test case more simple than the bug report at the origin of 71b88cf,
still involving grand-child relations though.
--
Michael

pgsql-bugs by date:

Previous
From: Michael Paquier
Date:
Subject: Re: [GENERAL] Need guidance on regression.diffs
Next
From: Michael Paquier
Date:
Subject: Re: BUG #11807: Postgresql server crashed when running transaction tests