Re: segfault when creating index on huge table

From: Yiqing Jin <yiqing(dot)jin(at)gmail(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: segfault when creating index on huge table
Date: 2015-07-17 04:35:08
Message-ID: 699EB2AC-7BF5-4BD3-AF59-2A5C682D3E69@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

this is very helpful information. thanks again!

> On Jul 16, 2015, at 8:16 PM, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
>
> Yiqing Jin <yiqing(dot)jin(at)gmail(dot)com> writes:
>> Yes it finished successfully after changing it to 50G!
>
> OK. That's only a workaround of course. I believe the actual problem
> is explained here:
> http://www.postgresql.org/message-id/flat/25168(dot)1437091531(at)sss(dot)pgh(dot)pa(dot)us
> If you need a fix before the next minor releases, see
> http://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=b8f368276916b677f0678982e81723fe30e5c582
>
> regards, tom lane

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Masaru Sugawara 2015-07-17 12:06:44 Re: リネージュIIオープンベータ登録完了のお知らせ
Previous Message Tom Lane 2015-07-17 03:16:11 Re: segfault when creating index on huge table