Another look into PostgreSQL CTE materialization and non-idempotent subqueries
Follow on to https://lobste.rs/s/ebsgja/postgresql_planner_gotcha_with_ctes and https://www.shayon.dev/post/2025/119/a-postgresql-planner-gotcha-with-ctes-delete-and-limit/

[Comments](https://lobste.rs/s/xev3l9 … ⌘ Read more