Postgres nurturing

Postgres has many settings and until recently we never really knew the full power or affects of tweaking these settings. There are a few hundred or so settings to tweak so it can seem a daunting task to any db admin, especially when performance is application critical! One wrong setting could potentially degrade the performance of your system , or worse cause it to stop working altogether!

I found this very interesting video on what settings to set and recommeneded values for them. They concentrate n the big 12. i have set to work on our dbs to change the settings and am recording the query times to see if we notice any dramatic effect.

Heres the video - http://vimeo.com/7109722

I will post the results of our findings once completed