Re: Sequential scan on FK join

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