You always need to check the resulting plans if you care about execution performance, that's just how life is. I'm offhand a bit surprised IN does worse than E

You always need to check the resulting plans if you care about execution performance, that's just how life is. I'm offhand a bit surprised IN does worse than EXISTS; I can understand NOT IN being slow, because it has very surprising NULL handling that is hard to optimize for.