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
Designing for Chaos: Implementing Circuit Breakers and Bulkheads in Go
0dev.to Go
Dashboard or spreadsheet: the honest test for when you need software
0dev.to Database
Database and PostgreSQL
0dev.to Database
Copy only the missing rows from SQL Server to PostgreSQL from the command line
0dev.to Database
Your PostgreSQL UPDATE ... FROM Never Finishes: The Repeated Target Table That Turns It Into a Cross Join
0dev.to Database
OfficePrism: Benchmarking Agents on Single-Domain Operations Across Enterprise Business Functions
0arXiv cs.SE