On reordering expressions in Postgres Today, we'll talk about one of those sneaky tricks that can help speed up query execution. Specifically, this is about reordering conditions in WHERE clauses, JOINs, HAVING clauses, and so on: u.habr.com/6y3h8