The real cost of random I/O

The random_page_cost was introduced ~25 years ago, and its default value has remained at 4.0 since then. Recent experiments suggest that the actual cost of reading a random page may be significantly higher than the default value, especially on SSDs. Lowering the random_page_cost may not always be the best solution, as there are various factors to consider in optimizing query planning.