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.
