Re: segfault when creating index on huge table - Mailing list pgsql-admin

From Yiqing Jin
Subject Re: segfault when creating index on huge table
Date
Msg-id 4D1580D9-D560-45B2-8BA2-97058B6F8D85@gmail.com
Whole thread Raw
In response to Re: segfault when creating index on huge table  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: segfault when creating index on huge table  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-admin
Yes it finished successfully after changing it to 50G!

Thanks Tom!

> On Jul 16, 2015, at 2:14 PM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
>
> Yiqing Jin <yiqing.jin@gmail.com> writes:
>> maintenance_work_mem = 128000MB
>
> Just a thought ... does the crash go away if you reduce that to something
> like 50GB?  It suddenly strikes me that qsort_tuple is not being careful
> about size_t being wider than int.
>
>             regards, tom lane



pgsql-admin by date:

Previous
From: Tom Lane
Date:
Subject: Re: segfault when creating index on huge table
Next
From: Tom Lane
Date:
Subject: Re: segfault when creating index on huge table