search

powa-team / powa

PostgreSQL Workload Analyzer
http://powa.readthedocs.io/
PostgreSQL License
768 stars 57 forks source link

Detect match random_page_cost for SSD storage #114

Closed guettli closed 5 years ago

guettli commented 5 years ago

If you are running PG on SSD storage, then you should lower random_page_cost.

See: https://dba.stackexchange.com/questions/204178/autodetect-random-page-cost-vs-seq-page-cost

Can powa detect and report this?

frost242 commented 5 years ago

Hello, This is out of the scope of PoWA. You should probably submit your question to the postgresqltuner project (https://github.com/jfcoz/postgresqltuner). Regards

guettli commented 5 years ago

Thank you for your fast reply. The postgresqltuner script looks good.