Re: GIN index creation extremely slow ?

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.