GoKawiilPostgreSQL blogger revisits random_page_cost defaults after POSETTE talk
A PostgreSQL performance researcher shared follow-up findings on the database's random_page_cost setting, which governs how the query planner estimates the cost of random versus sequential disk reads. New benchmark data from older rotational SATA drives showed an estimated cost around 125, far higher than the long-standing default of 4.0, while SSD-based tests land closer to that default only by coincidence.