Hey Guys, Any further thoughts on this?
Thanks, Carson On Jan 7, 1:35 pm, Carson Gross <carsongr...@gmail.com> wrote: > Sure. We've got a big, ugly database that we are constantly slamming > data into (nearly constant appends on one table, with occasionally > purges.) We'd like to increase the checkpoint segments to see if that > boosts write performance. > > On the cache side, according to this website: > > http://wiki.postgresql.org/wiki/Tuning_Your_PostgreSQL_Server > > "Setting effective_cache_size to 1/2 of total memory would be a normal > conservative setting, and 3/4 of memory is a more aggressive but still > reasonable amount." > > Again, as near as I can tell, the default in Heroku is to set it to > 200MB. We are running a ronin database, which should have 1.7 Gigs of > RAM, giving 850MB to 1.3 GB of cache as the ideal, at least according > to that wiki entry. > > Our goal is to extract maximum performance with minimum effort and bug > creation and, therefore, tweaking some postgres parameters would be an > ideal way to do so. Let me know if you need any more details on our > use case. > > Thanks! > Carson > > On Jan 7, 12:40 pm, Matthew Soldo <m...@heroku.com> wrote: > > > > > Hi Carson, > > > We don't support tuning the dedicated database. > > > I'd love to hear more about your requirements and needs around this. It's > > possible that this could be supported in the future. > > > Matt > > > On Fri, Jan 7, 2011 at 10:50 AM, Carson Gross <carsongr...@gmail.com> wrote: > > > Is it possible to tune a dedicated postgres database? In particular, > > > we'd like to change the effective cache size and checkpoint segments > > > setting from the defaults (appear to be ~200MB and 40, respectively.) > > > > Cheers, > > > Carson > > > > -- > > > You received this message because you are subscribed to the Google Groups > > > "Heroku" group. > > > To post to this group, send email to her...@googlegroups.com. > > > To unsubscribe from this group, send email to > > > heroku+unsubscr...@googlegroups.com<heroku%2bunsubscr...@googlegroups.com> > > > . > > > For more options, visit this group at > > >http://groups.google.com/group/heroku?hl=en. -- You received this message because you are subscribed to the Google Groups "Heroku" group. To post to this group, send email to her...@googlegroups.com. To unsubscribe from this group, send email to heroku+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/heroku?hl=en.