It's difficult to give exact rules: the best results are found from experimentation.
This is a useful (if slightly out of date) reference: http://www.varlena.com/GeneralBits/Tidbits/annotated_conf_e.html In any case, you'll certainly want to be increasing shared_buffers, temp_buffers and work_mem. We also increased maintenance_work_mem to give autovacuum room to breathe: shared_buffers = 3000 temp_buffers = 4096 work_mem = 2048 maintenance_work_mem = 32768 I knocked up default_statistics_target to 20. For autovacuum to work (recommended) you need these: stats_start_collector = on stats_row_level = on autovacuum = on I haven't tuned anything else as we're watching performance for now and seeing how it goes. Hope this helps... On Wed, 2006-09-13 at 12:33 -0400, Brad Anderson wrote: > Russ Brown wrote: > > My only other comment would be that if you do decide to upgrade, ensure > > that you tune postgresql.conf if you want decent performance. The > > defaults are intentionally very conservative to ensure that the server > > will run pretty much anywhere. > > Can you provide examples of what you changed? > > BA > > > --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Trac Users" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/trac-users -~----------~----~----~----~------~----~------~--~---
