[Tracker-discuss] Speeding up indexer_rdbms

Erik Forsberg forsberg at efod.se
Wed Aug 22 08:01:51 CEST 2007


-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

"Martin v. Löwis" <martin at v.loewis.de> writes:

> I found that the creation of two additional postgres indices, namely
>
> create index words_textid_idx on __words(_textid);
> create index textids_class_itemid_prop_idx on __textids (_class,
> _itemid, _prop);

Interesting. This was discussed a month ago on roundup-devel. See
http://permalink.gmane.org/gmane.comp.bug-tracking.roundup.devel/4609

So, it's in roundup CVS, but not in the version we run. The latter can
of course be fixed before doing the final import. I'll take a look.

Regards,
\EF
- -- 
Erik Forsberg                 http://efod.se
GPG/PGP Key: 1024D/0BAC89D9
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.6 (GNU/Linux)
Comment: Processed by Mailcrypt 3.5.8+ <http://mailcrypt.sourceforge.net/>

iD8DBQFGy9FPrJurFAusidkRAjaIAJ9RwULIZDR3ZKVePpgyLgqglF9SdgCeNy8s
09Te+G1MBJdkrR/jB/tohsw=
=XHWO
-----END PGP SIGNATURE-----


More information about the Tracker-discuss mailing list