Skip to main content
1 of 3
guettli
  • 1.6k
  • 5
  • 24
  • 51

Autodetect ‘random_page_cost’ vs ‘seq_page_cost’

I read this article about PostgreSQL performance on SSD:

https://amplitude.engineering/how-a-single-postgresql-config-change-improved-slow-query-performance-by-50x-85593b8991b0

These two configurations seem to be important random_page_cost vs seq_page_cost

Since both parameters need to match the particular hardware I wonder if it is possible to automatically detect the matching values?

guettli
  • 1.6k
  • 5
  • 24
  • 51