Heroku Postgres Shared Buffer Cache configurability

heroku / roadmap

This is the public roadmap for Salesforce Heroku services.

195 stars 11 forks source link

Heroku Postgres Shared Buffer Cache configurability #234

Open abernicchia-heroku opened 1 year ago

abernicchia-heroku commented 1 year ago

Required Terms

[X] I agree to follow this project's Code of Conduct
[X] I have read and accept the Salesforce Program Agreement

What service(s) is this request for?

Heroku Postgres

Tell us about what you're trying to solve. What challenges are you facing?

Allowing the possibility to configure Postgres "Shared Buffer Cache" currently configured to be about 25% of total system memory.

bf4 commented 8 months ago

Our database consultant was surprised this wasn't already a thing for our database and found this issue. They said this is a pretty standard tool for database tuning. As a leader in managed Postgres, it seems like this would be a win to bring Heroku to parity with other vendors like CrunchyBridge, AWS, Azure, GCP.

jbrown-heroku commented 4 months ago

We are looking to offer this as part of the future Heroku database offering on the new infrastructure. At this time, we have made adjustments to our shared_buffers and work_mem default values: https://devcenter.heroku.com/changelog-items/2796 We want to deliver great performance for as many of our customers. If the adjustments we made is not meeting your requirement, please let us know.

bf4 commented 4 months ago

Those adjustments are better

jbrown-heroku commented 4 months ago

Thank you for the feedback @bf4 !