> creating a CTE doesn't really materialize any of the resulting steps' data Well, at least with PostgreSQL -- all CTEs were always materialized. It was optimi

> creating a CTE doesn't really materialize any of the resulting steps' data Well, at least with PostgreSQL -- all CTEs were always materialized. It was optimized only in the version 12.