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: (view raw, whole thread or download thread mbox)
Lists: pgsql-hackers
> test=# CREATE INDEX idxFTI_idx ON wikipedia USING gist(vector);
> Time: 416122.896 ms
> so about 7 minutes - sounds very reasonable
> test=# CREATE INDEX idxFTI2_idx ON wikipedia USING gin(vector);
> 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

In response to


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-2017 The PostgreSQL Global Development Group