X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [64.117.224.130]) by svr1.postgresql.org (Postfix) with ESMTP id 32CEDD1B56B for ; Sun, 31 Aug 2003 00:09:56 +0000 (GMT) Received: from svr1.postgresql.org ([64.117.224.193]) by localhost (neptune.hub.org [64.117.224.130]) (amavisd-new, port 10024) with ESMTP id 71365-06 for ; Sat, 30 Aug 2003 21:09:48 -0300 (ADT) Received: from pass.bivio.com (locker.bivio.com [216.87.82.238]) by svr1.postgresql.org (Postfix) with ESMTP id 47FAAD1B899 for ; Sat, 30 Aug 2003 21:09:36 -0300 (ADT) Received: from LIFT.bivio.com (lift.bivio.com [216.87.82.233]) by pass.bivio.com (8.9.3/8.9.3) with ESMTP id SAB25632 for ; Sat, 30 Aug 2003 18:09:39 -0600 From: Rob Nagler MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Message-ID: <16209.14949.507000.384083@gargle.gargle.HOWL> Date: Sat, 30 Aug 2003 17:59:33 -0600 To: PgSQL Performance ML Subject: Re: How to force Nested Loop plan? In-Reply-To: <1062278901.669.597.camel@haggis> References: <16208.41885.960000.12706@gargle.gargle.HOWL> <24637.1062255721@sss.pgh.pa.us> <16208.50934.351000.90704@gargle.gargle.HOWL> <2074.1062260382@sss.pgh.pa.us> <16209.3105.94000.204936@gargle.gargle.HOWL> <1062278901.669.597.camel@haggis> X-Mailer: VM 6.96 under Emacs 21.1.1 Organization: bivio Software Artisans, Inc. X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200308/546 X-Sequence-Number: 3362 Ron Johnson writes: > Dumb question: given your out-of-the-box satisfaction, could it be > that postgresql.conf hasn't been tweaked? Here are the modified values: shared_buffers = 8000 wal_buffers = 80 sort_mem = 32000 effective_cache_size = 400000 random_page_cost = 4 autocommit = false timezone = UTC I had run a test with effective_cache_size to high value to see what would happen. Also adjusted random_page_cost: random_page_cost effective_cache_size elbow 4 40000 675 .5 40000 592 .1 40000 392 4 1000 30 My conclusion is that random_page_cost should be left alone and effective_cache_size higher is better. BTW, the hardware is 2 x 2.4ghz Xeon, 1.2GB, SCSI (linux software raid) with 10K disks. This is close to the production box. Although we are planning on adding more memory to production. Rob