This question appeared couple of times on irc, so I figured I can do a blogpost about it.

Some time ago I wrote a blogpost about why index might not be used. While this post seemed to be well received (top link from depesz.com on reddit), it doesn't answer another question - what index to create for given situation. I'll ...