Teodor Sigaev wrote: >> test=# CREATE INDEX idxFTI_idx ON wikipedia USING gist(vector); >> CREATE INDEX >> Time: 416122.896 ms >> >> so about 7 minutes - sounds very reasonable >> >> test=# CREATE INDEX idxFTI2_idx ON wikipedia USING gin(vector); >> CREATE INDEX >> Time: 52681605.101 ms > > I'll look at this, but GiST time creation is suspiciously small. > Can you test on smaller table, for example with 100000 records and if > results are repeat, pls, send to me test suite...
I won't have access to the original testcase and server for a few days but I just redid some testing on a slower personal box of mine with a smaller(but similiar) testset and on that box I could not reproduce that issue. So the problem is either caused by the size of the table or somehow by the data itself :-( Stefan ---------------------------(end of broadcast)--------------------------- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq