Comment by aidos

Worth reading. I had no idea you can do conditional indexes. Is that something other dbs support? (looks like mysql doesn't)