postgres

When a CTE makes a Postgres query faster

What a WITH clause changes in the plan, measured on 2 million rows, and how to write the same queries in Rails.