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.

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.1 (GNU/Linux)

iD8DBQFEokn/IB7bNG8LQkwRAodXAJ47knDv5piGnaI7fOP2Uo8h9wdL4gCeLE ++
TCsMzZjCxbX1Q2v4PuuJRp4=
=bYsX
-----END PGP SIGNATURE-----