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@svana.org> http://svana.org/kleptog/ > From each according to his ability. To each according to his ability to > litigate.
signature.asc
Description: Digital signature
