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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-hackers by date

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