ND A PostgreSQL planner semi-join gotcha with CTE, LIMIT, and RETURNING (www.shayon.dev)
57 points by namanyayg 310 days ago | 50 comments on HN ~lite vlite-2.0
Summary ~lite
Technical article discusses a PostgreSQL planner gotcha with CTEs, DELETE, and LIMIT.
Lite evaluation by llama-4-scout-wai-psq · editorial channel only · no per-section breakdown available
Longitudinal · 6 evals
+1 0 −1 HN
Audit Trail 12 entries
2026-03-05 12:40 eval_success PSQ evaluated: g-PSQ=0.280 (3 dims) - -
2026-03-05 12:40 eval Evaluated by llama-4-scout-wai-psq: +0.28 (Mild positive) 0.00
2026-03-05 12:33 eval_success PSQ evaluated: g-PSQ=0.280 (3 dims) - -
2026-03-05 12:33 eval Evaluated by llama-4-scout-wai-psq: +0.28 (Mild positive)
2026-03-05 12:23 eval_success PSQ evaluated: g-PSQ=0.161 (3 dims) - -
2026-03-05 12:23 eval Evaluated by llama-3.3-70b-wai-psq: +0.16 (Mild positive)
2026-03-01 18:18 eval_success Lite evaluated: Neutral (0.00) - -
2026-03-01 18:18 eval Evaluated by llama-3.3-70b-wai: 0.00 (Neutral) 0.00
reasoning
Technical tutorial on PostgreSQL
2026-03-01 18:18 eval_success Lite evaluated: Neutral (0.00) - -
2026-03-01 18:18 eval Evaluated by llama-4-scout-wai: 0.00 (Neutral)
reasoning
ED technical article on PostgreSQL query optimization
2026-03-01 18:13 eval_success Lite evaluated: Neutral (0.00) - -
2026-03-01 18:13 eval Evaluated by llama-3.3-70b-wai: 0.00 (Neutral)
reasoning
Technical tutorial on PostgreSQL