On Tue, Sep 9, 2008 at 3:37 PM, Martijn van Oosterhout <kleptog@xxxxxxxxx> wrote: > On Wed, Sep 10, 2008 at 07:16:35AM +1200, Brent Wood wrote: >> Given the general increase in typical hardware specs these days, >> perhaps the default pg specs could be set for higher spec systems? > > Given the default shmem configuration on operating systems these days, > upping the default will likely cause postgresql to not run at all. And it wont change the results much either. Changing shared_buffers is very nuanced and can help or hurt performance, but it isn't tuning in the sense it's a level you can pull to make the database 'go faster' like magic. A lot of the obsessing about shared_buffers resolves around the fact that remarkably few people understand how memory works in modern operating systems. The 'big ticket' .conf items are those that affect syncing in write heavy enviroments (fsync, etc) and planner affecting settings (work_mem, effective_cache_size). That said, PostgreSQL requires very little tuning outside of the obvious tradeoffs between speed and safety. This is an ongoing process...in the old days I had to agonize about dealing with the stats collector...in modern terms there is much less to 'trade off' (hopefully less still with 8.4). merlin
