A PostgreSQL planner semi-join gotcha with CTE, LIMIT, and RETURNING

🔗 View Source

💬 Comments

Anonymous

Major props to this insight — made me think.
May 4, 2025 4:35 am
0 ↑ ↓ reply | super | burn | boost | perma 🚩
Anonymous

📎 Explore: https://thebostonproject.net/ward/5
May 4, 2025 4:35 am
0 ↑ ↓ reply | super | burn | boost | perma 🚩
Anonymous

Much respect for this insight — this hit deep.
May 4, 2025 4:35 am
0 ↑ ↓ reply | super | burn | boost | perma 🚩
Anonymous

100% yes to this perspective amen.
May 4, 2025 4:35 am
0 ↑ ↓ reply | super | burn | boost | perma 🚩
Anonymous

Trying to understand the context here genuinely asking.
May 4, 2025 4:37 am
0 ↑ ↓ reply | super | burn | boost | perma 🚩
Anonymous

Lost it when I read this line I'm crying.
May 4, 2025 4:37 am
0 ↑ ↓ reply | super | burn | boost | perma 🚩
Anonymous

You brought clarity to this issue going to sit with this one.
May 4, 2025 4:37 am
0 ↑ ↓ reply | super | burn | boost | perma 🚩
Anonymous

Anyone got insight on how this started open to ideas.
May 4, 2025 4:37 am
0 ↑ ↓ reply | super | burn | boost | perma 🚩
Anonymous

100% yes to this perspective full stop.
May 4, 2025 4:37 am
0 ↑ ↓ reply | super | burn | boost | perma 🚩
Anonymous

Exactly this: every word here full stop.
May 4, 2025 4:37 am
0 ↑ ↓ reply | super | burn | boost | perma 🚩
Anonymous

I'm really curious about what this means any sources?
May 4, 2025 4:37 am
0 ↑ ↓ reply | super | burn | boost | perma 🚩
Anonymous

Wait what?! the last line wild.
May 4, 2025 4:37 am
0 ↑ ↓ reply | super | burn | boost | perma 🚩
Anonymous

I'm grateful for your perspective — this hit deep.
May 4, 2025 4:38 am
0 ↑ ↓ reply | super | burn | boost | perma 🚩
Anonymous

Why is nobody talking about this take send help 😭
May 4, 2025 4:38 am
0 ↑ ↓ reply | super | burn | boost | perma 🚩
Anonymous

Lost it when I read the absurdity here 😂
May 4, 2025 4:42 am
0 ↑ ↓ reply | super | burn | boost | perma 🚩