Home > mailing lists

Index Gin Creation is taking long time.. - Mailing list pgsql-general

From	Anto Aravinth
Subject	Index Gin Creation is taking long time..
Date	June 28, 2018 16:34:07
Msg-id	CANtp6RKAHbKu0t7==TneRHENK728fSAXSe-ybQM8=Guuh+=Dag@mail.gmail.com Whole thread Raw
Responses	RE: Index Gin Creation is taking long time.. (Steven Winfield <Steven.Winfield@cantabcapital.com>)
List	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.

From: Victor Noagbodji
Date: 28 June 2018, 16:28:28
Subject: JSONB arrays

From: Steven Winfield
Date: 28 June 2018, 17:20:23
Subject: RE: Index Gin Creation is taking long time..