Login
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
How a seemingly straightforward DELETE query using a CTE and LIMIT returned more rows than expected due to query planner optimization.
Roast topics
Find topics
Roast it!
Roast topics
Find topics
Find it!
Roast topics
Find topics
Find it!