Login
Roast topics
Find topics
Find it!
From:
Shayon Mukherjee
(Uncensored)
subscribe
A PostgreSQL planner gotcha with CTEs DELETE and LIMIT
https://www.shayon.dev/post/2025/119/a-postgresql-planner-gotcha-with-ctes-delete-and-limit/
links
backlinks
Tagged with:
optimization
sql
database
postgresql
cte
Roast topics
Find topics
Roast it!
How a seemingly straightforward DELETE query using a CTE and LIMIT returned more rows than expected due to query planner optimization.