Re: BUG #11811: Server segfault with many subpartitions when using nestloop

On 29/10/14 02:35, Michael Paquier wrote:
> On Wed, Oct 29, 2014 at 3:00 AM, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
>> federico(at)brandwatch(dot)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.
>

Thanks.
I'll wait for the 9.2.10 before upgrading.

Many thanks

--
Federico Campoli
Brandwatch | Senior Database Administrator
federico(at)brandwatch(dot)com |

New York | San Francisco | *Brighton* | Berlin | Stuttgart