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
pgsql-hackers by date
|Next:||From: Thomas Hallgren||Date: 2006-06-28 10:03:40|
|Subject: Re: UUID's as primary keys|
|Previous:||From: Teodor Sigaev||Date: 2006-06-28 09:09:23|
|Subject: Re: GIN index creation extremely slow ?|