July 3rd, 2017 by depesz | Tags: constraint, count, howto, postgresql, trigger, tutorial | 10 comments »
This question appeared couple of times on irc, so I figured I can do a blogpost about it.
September 28th, 2011 by depesz | Tags: index, multicolumn, partial index, performance, postgresql, tutorial | 9 comments »
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 ...