Re: [WIP] speeding up GIN build with parallel workers

From: David Steele <david(at)pgmasters(dot)net>
To: Oleg Bartunov <obartunov(at)gmail(dot)com>
Cc: "Constantin S(dot) Pan" <kvapen(at)gmail(dot)com>, Pgsql Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: [WIP] speeding up GIN build with parallel workers
Date: 2016-03-14 12:42:26
Message-ID: 56E6B1B2.1040606@pgmasters.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On 2/18/16 10:10 AM, Constantin S. Pan wrote:
> On Wed, 17 Feb 2016 23:01:47 +0300
> Oleg Bartunov <obartunov(at)gmail(dot)com> wrote:
>
>> My feedback is (Mac OS X 10.11.3)
>>
>> set gin_parallel_workers=2;
>> create index message_body_idx on messages using gin(body_tsvector);
>> LOG: worker process: parallel worker for PID 5689 (PID 6906) was
>> terminated by signal 11: Segmentation fault
>
> Fixed this, try the new patch. The bug was in incorrect handling
> of some GIN categories.

Oleg, it looks like Constantin has updated to patch to address the issue
you were seeing. Do you have time to retest and review?

Thanks,
--
-David
david(at)pgmasters(dot)net

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message David Steele 2016-03-14 13:02:06 Re: [WIP] Effective storage of duplicates in B-tree index.
Previous Message Tomas Vondra 2016-03-14 12:33:08 Re: Re: PATCH: Split stats file per database WAS: autovacuum stress-testing our system