3 ms·
The partial index tip is great for that kind of problem (you need a fast query for a subset of your data).
by hcarvalhoalves 14y ago
The partial index tip is great for that kind of problem (you need a fast query for a subset of your data).
- aidos 14y agoIt's great, it was new to me too. There's a discussion we had about it the other day over here http://news.ycombinator.com/item?id=5039042 http://news.ycombinator.com/item?id=5039042
- pjungwir 14y agoI wrote a gem to help you create partial indexes (among other things) in Rails projects: https://github.com/pjungwir/db_leftovers https://github.com/pjungwir/db_leftovers