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
How I Architected ResFlows: A Zero-Login AI Resume Screener with Next.js 16 & Prisma 7
0dev.to
Before You Let AI Build Enterprise Systems, Build the Approval Pipeline First
0dev.to

TETRA Wants to Reinvent the Database. Its Ambitions Go Much Further
0HackerNoon
Before You Renew Snowflake, Run These 6 Queries
0HackerNoon
How Sprig Replaced Postgres, ClickHouse & Redis…with 4-8x Better Latency
0HackerNoon
Navicat Introduces Navicat 18 for PostgreSQL: Experience Enterprise-Grade PostgreSQL Database Management and Development
0PostgreSQL News