Tag Info

New answers tagged


I run into this issue a lot, and discovered a simple 2-part trick. Create substring index on the hash value : (7 is usually a good length) create index methods_idx_hash_substring ON methods(substring(hash,1,7)) Have your searches/joins include a substring match, so the query planner is hinted to use the index: old: WHERE hash = :kwarg new: WHERE (hash ...

Top 50 recent answers are included