Index Gin Creation is taking long time..

From: Anto Aravinth <anto(dot)aravinth(dot)cse(at)gmail(dot)com>
To: "pgsql-generallists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Index Gin Creation is taking long time..
Date: 2018-06-28 10:34:07
Message-ID: CANtp6RKAHbKu0t7==TneRHENK728fSAXSe-ybQM8=Guuh+=Dag@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello,

I'm trying to create an index:

create index search_idx on so2 using gin (to_tsvector('english',posts));

Looks like its running atleast for 8hours :( Totally I have 47M records in
so2. Not sure why its taking so long time.

Any idea or tips to debug while the index creation is going on?

Thanks,
Anto.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Steven Winfield 2018-06-28 11:20:23 RE: Index Gin Creation is taking long time..
Previous Message Victor Noagbodji 2018-06-28 10:28:28 JSONB arrays