RE: Index Gin Creation is taking long time..

2018-06-28 Thread Steven Winfield
From: Anto Aravinth [mailto:anto.aravinth@gmail.com] Sent: 28 June 2018 11:34 To: pgsql-generallists.postgresql.org Subject: Index Gin Creation is taking long time.. Hello, I'm trying to create an index: create index search_idx on so2 using gin (to_tsvector('english',

Index Gin Creation is taking long time..

2018-06-28 Thread Anto Aravinth
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? T