>>Are CTEs still optimization fences?>https://www.2ndquadrant.com/en/blog/postgresql-ctes-are-optimization-fences/
Yes, but not in 12.
Regards, Andreas
-- 2ndQuadrant - The PostgreSQL Support Company