Hacker News
Some more thoughts on random_page_cost
The author revisits random_page_cost, showing measurements on old SATA disks that yield an estimated cost around 125—far higher than the default 4.0—while SSDs produce values nearer the default by coincidence. He argues that the cost model ignores memory usage and data locality, causing random_page_cost to compensate for these omitted factors.