How can I change the postgres random_page_cost on Heroku?

user_605331 0
Viewed 2477

On a Heroku-managed instance of postgres the default value for random_page_cost is 2.0. I'd like to change the value, but don't see a way to do so. How can I change that value?

heroku postgresql
2 Answers

You can alter the database to get the number you want.

alter database mydb set random_page_cost=1.4;
user_5089080
Related