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

Re: GIN index creation extremely slow ?

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

In response to

Responses

pgsql-hackers by date

Next:From: Bruce MomjianDate: 2006-06-27 22:14:04
Subject: Re: [HACKERS] Overhead for stats_command_string et al, take
Previous:From: Bruce MomjianDate: 2006-06-27 19:07:05
Subject: Re: [HACKERS] Overhead for stats_command_string et al, take

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