Skip site navigation (1) Skip section navigation (2)

Re: GIN index creation extremely slow ?

From: Teodor Sigaev <teodor(at)sigaev(dot)ru>
To: Stefan Kaltenbrunner <stefan(at)kaltenbrunner(dot)cc>
Cc: PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: GIN index creation extremely slow ?
Date: 2006-06-27 11:58:02
Message-ID: 44A11D4A.40602@sigaev.ru (view raw or flat)
Thread:
Lists: pgsql-hackers
> 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...

-- 
Teodor Sigaev                                   E-mail: teodor(at)sigaev(dot)ru
                                                    WWW: http://www.sigaev.ru/

In response to

Responses

pgsql-hackers by date

Next:From: Mark WoodwardDate: 2006-06-27 12:48:19
Subject: Re: vacuum, performance, and MVCC
Previous:From: Dhanaraj MDate: 2006-06-27 10:37:48
Subject: Turning off disk caching

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group