[davyjones]

Off the top of my head, Index only scans, overhauled GIN & GiST indices, Trigrams come to mind.