Database
Alexander Ioffe: I ran the same query twice and Postgres disagreed with itself
Planet PostgreSQL0 views
Two EXPLAIN ANALYZE runs on statistically identical data produced opposite plans, 73 heap blocks against 3,449. The margin was 1.5%. Here's the mechanism, measured with ExoBench, and the index shape that takes the coin out of the planner's hand.
Source:https://postgr.es/p/9x1PreviousChristophe Pettus: All Your GUCs in a Row: notify_buffersNextPrateek Arora: I timed 179 index recommendations on real data. 18% made the query slower.
Related posts

agent-chat 2.0.0: message ids, replies and JSON output for agents that talk to each other
0dev.to AI
What Is Docker and Why Developers Love It
0dev.to
Node.js Webhook Subscribe: HTTPS Push, Rate Limits, Ack/Nack, Dead Letters
0dev.to
Show DEV: I built a Full-Stack AI Agent & Visual Workflow SaaS Starter Kit (React 19 + Node.js + Prisma)
0dev.to React
Database Isolation Levels: Why Defaults Break Production
0dev.to DevOps
GitHub used to be people building in C. Now it's skills made of skills made of skills.
0dev.to Discuss