On 29/10/14 02:35, Michael Paquier wrote:
> 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.
>
Thanks.
I'll wait for the 9.2.10 before upgrading.
Many thanks
--
Federico Campoli
Brandwatch | Senior Database Administrator
federico@brandwatch.com |
New York | San Francisco | *Brighton* | Berlin | Stuttgart