On 11-09-02 09:33 PM, Rob Lanphier wrote: > On Fri, Sep 2, 2011 at 5:47 PM, Daniel Friesen > <[email protected]> wrote: >> On 11-09-02 05:20 PM, Asher Feldman wrote: >>> When using for analysis, will we wish the new columns had partial indexes >>> (first 6 characters?) >> Bug 2939 is one relevant bug to this, it could probably use an index. >> [1] https://bugzilla.wikimedia.org/show_bug.cgi?id=2939 > My understanding is that having a normal index on a table the size of > our revision table will be far too expensive for db writes. > ... > Rob We've got 5 normal indexes on revision: - A unique int+int - A binary(14) - An int+binary(14) - Another int+binary(14) - And a varchar(255)+binary(14)
That bug wise a (rev_page,rev_sha1) or (rev_page,rev_timestamp,rev_sha1) may do. -- ~Daniel Friesen (Dantman, Nadir-Seen-Fire) [http://daniel.friesen.name] _______________________________________________ Wikitech-l mailing list [email protected] https://lists.wikimedia.org/mailman/listinfo/wikitech-l
