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 to network for an internship as a college student
0dev.to
Show HN: PG Import Check – Analyze PostgreSQL schemas before importing data
0Hacker News Show
Built on object storage, served from cache
0Databricks Blog
1,715 npm downloads and zero sales: I measured the whole funnel
0dev.to Discuss
When an Upgrade Crashes on Startup: A Merged Keycloak Fix
0dev.to Java
Quartz job not firing? Causes and how to check
0dev.to Java