>>>Bruce Momjian said: > > I imagined they could run pgtune anytime after install to update those > performance parameters. It gives them a one-stop location to at least > do minimal tuning, and as their load changes, they can run it again.
True, but to make reasonably good choice, they will need to base the parameter selection on some statistics data. Not many people do trough testing before tuning their system and in many cases, the tests one do rarely resemble the real-world usage of their database(s). I agree that pgtune would be wonderful tool in this case, but they first need to get some idea what parameters should be given to it. This process if further complicated by the fact that we can tune PostgreSQL on a per-installation basis, instead of on per-database basis - many of the parameters, for example FSM and sort memory are database related. We usually split data into databases to put related data together or data with similar usage pattern etc. Daniel ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
