powa-team/powa

Detect match random_page_cost for SSD storage

guettli opened this issue · 2 comments

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?

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

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