Search Postgresql Archives

Index Gin Creation is taking long time..

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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. 

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux