date: "2025-05-04" stories: - title: A PostgreSQL planner semi-join gotcha with CTE, LIMIT, and RETURNING url: https://www.shayon.dev/post/2025/119/a-postgresql-planner-gotcha-with-ctes-delete-and-limit/ source: HackerNews hn_url: https://news.ycombinator.com/item?id=43883732 points: 57 comments: 50 author: namanyayg created_at: "2025-05-04T01:24:14Z" - title: AWS Blog on Postgres Long Fork Anomaly (Response to Jepsen Report) url: https://aws.amazon.com/blogs/database/understanding-transaction-visibility-in-postgresql-clusters-with-read-replicas/ source: HackerNews hn_url: https://news.ycombinator.com/item?id=43884003 points: 18 author: talawahtech created_at: "2025-05-04T02:27:23Z" - title: 'Show HN: Pomerium Agentic Access Gateway – dynamic auth for AI agents' url: https://news.ycombinator.com/item?id=43887439 source: HackerNews hn_url: https://news.ycombinator.com/item?id=43887439 points: 10 author: bdesimone created_at: "2025-05-04T15:53:48Z" - title: 'Ask HN: I''m a New PostgreSQL Hacker – What Problems Do You Face with Postgres?' url: https://news.ycombinator.com/item?id=43886414 source: HackerNews hn_url: https://news.ycombinator.com/item?id=43886414 points: 7 comments: 14 author: DumBthInker007 created_at: "2025-05-04T12:46:51Z" - title: Another look into PostgreSQL CTE materialization and non-idempotent subqueries url: https://www.shayon.dev/post/2025/124/another-look-into-postgresql-cte-materialization-and-non-idempotent-subqueries/ source: HackerNews hn_url: https://news.ycombinator.com/item?id=43887578 points: 5 author: craigkerstiens created_at: "2025-05-04T16:15:00Z" - title: 'Show HN: Next.js and PostgreSQL Stock News Visualizer' url: https://amitavkrishna.com/stocks source: HackerNews hn_url: https://news.ycombinator.com/item?id=43887609 points: 2 author: amitav1 created_at: "2025-05-04T16:20:30Z"