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
Building an Open-Source RAG Application: What I Learned from Cairnly
0dev.to Machine Learning
Understanding BugSigDB and Its Curation Policy
0dev.to OpenSource

Branch isolation in a live Supabase app
0dev.to Database
LSM-Trees vs B-Trees: Which Side of the Disk You Tax
0dev.to Database
A 9-TiB OLTP Benchmark on PostgreSQL
0dev.to Database
Faster SSDs for PostgreSQL: From Read I/O to WAL Waits
0dev.to Database