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

Re: GIN index creation extremely slow ?

From: Martijn van Oosterhout <kleptog(at)svana(dot)org>
To: Teodor Sigaev <teodor(at)sigaev(dot)ru>
Cc: Stefan Kaltenbrunner <stefan(at)kaltenbrunner(dot)cc>,PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: GIN index creation extremely slow ?
Date: 2006-06-28 09:21:03
Message-ID: 20060628092103.GA32530@svana.org (view raw or flat)
Thread:
Lists: pgsql-hackers
On Wed, Jun 28, 2006 at 01:09:23PM +0400, Teodor Sigaev wrote:
> We tested gin with 5 millions records (but not a wikipedia's text, but with 
> blog records which is usually mush shorter) and index creation time was 
> near 8 hours on Dual Xeon 3.2, but we didn't try GiST. In other hand, 
> creating GiST index on 0.5 millions emails took about 12 hours.
> 
> That's why 7 minutes is very suspicious result.

Tom did commit a patch a while ago which made a huge difference in
index creation time for tsearch by changing one routine. I don't know
if it got backpatched, so it might be worth checking people are working
on the same version.

Have a nice day,
-- 
Martijn van Oosterhout   <kleptog(at)svana(dot)org>   http://svana.org/kleptog/
> From each according to his ability. To each according to his ability to litigate.

In response to

Responses

pgsql-hackers by date

Next:From: Thomas HallgrenDate: 2006-06-28 10:03:40
Subject: Re: UUID's as primary keys
Previous:From: Teodor SigaevDate: 2006-06-28 09:09:23
Subject: Re: GIN index creation extremely slow ?

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