Interesting set of SQL optimizations. Also shows PostgreSQL still had (has?) some room for improvement.