X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 19D95D818E for ; Fri, 21 Oct 2005 05:41:43 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 42565-05 for ; Fri, 21 Oct 2005 08:41:40 +0000 (GMT) Received: from floppy.pyrenet.fr (floppy.pyrenet.fr [194.116.145.2]) by svr1.postgresql.org (Postfix) with ESMTP id 3D462D7D4D for ; Fri, 21 Oct 2005 05:41:41 -0300 (ADT) Received: by floppy.pyrenet.fr (Postfix, from userid 106) id 2A6AC31059; Fri, 21 Oct 2005 10:41:43 +0200 (MET DST) From: Martin Nickel X-Newsgroups: pgsql.performance Subject: Re: Sequential scan on FK join Date: Fri, 21 Oct 2005 03:51:56 -0500 Organization: Hub.Org Networking Services Lines: 26 Message-ID: References: <4353648C.8040507@archonet.com> <4353E342.2060708@archonet.com> <4354A9AF.30300@archonet.com> Mime-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 8bit X-Complaints-To: usenet@news.hub.org User-Agent: Pan/0.14.2 (This is not a psychotic episode. It's a cleansing moment of clarity.) To: pgsql-performance@postgresql.org X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0 required=5 tests=[none] X-Spam-Level: X-Archive-Number: 200510/294 X-Sequence-Number: 15062 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