On Tue, 18 Oct 2005 08:52:15 +0100, Richard Huxton wrote: > 3. Actually - are you happy that your general configuration is OK? We're running dual Opteron 244s with 4G of memory. The platform is Suse 9.3, 64 bit. The database is on a 3ware 9500S-8 sata raid controller configured raid 10 with 4 drives plus a hot swap. Drives are 7400 rpm (don't remember model or size).
I'm running Postgres 8.0.3. Here are some of the relevant conf file parameters: shared_buffers = 50000 sort_mem = 8192 work_mem = 256000 vacuum_mem = 32768 max_fsm_pages = 40000 max_fsm_relations = 1000 I realize shared_buffers is too high. Not sure on the others. Thanks for any help you can suggest. I've moved most of these around some and restarted without any clear changes for the better or worse (just seat-of-the-pants feel - I haven't tried to benchmark the result of changes at all). Thanks, Martin ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings