X-Original-To: pgsql-performance-postgresql.org@postgresql.org Received: from localhost (wm.hub.org [200.46.204.128]) by postgresql.org (Postfix) with ESMTP id 3C8909FB334 for ; Mon, 21 Aug 2006 17:25:08 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.128]) (amavisd-new, port 10024) with ESMTP id 53749-06 for ; Mon, 21 Aug 2006 20:24:55 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey- Received: from mail.intrusic.com (mail.intrusic.com [63.251.138.101]) by postgresql.org (Postfix) with ESMTP id CE36C9FB307 for ; Mon, 21 Aug 2006 17:24:52 -0300 (ADT) Received: from cha1-mail1.intrusic.com (unknown [65.223.207.194]) by mail.intrusic.com (Postfix) with ESMTP id 33644FB3; Mon, 21 Aug 2006 16:02:52 -0500 (EST) Received: from [127.0.0.1] (unknown [192.168.100.126]) by cha1-mail1.intrusic.com (Postfix) with ESMTP id 46D1DC5666; Mon, 21 Aug 2006 12:19:35 -0400 (EDT) Message-ID: <44EA16A6.6080607@intrusic.com> Date: Mon, 21 Aug 2006 16:25:10 -0400 From: Scott Matseas User-Agent: Thunderbird 1.5.0.5 (Windows/20060719) MIME-Version: 1.0 To: Tom Lane Cc: pgsql-performance@postgresql.org Subject: Re: Index usage References: <44E9EEF9.7050901@intrusic.com> <5599.1156184779@sss.pgh.pa.us> In-Reply-To: <5599.1156184779@sss.pgh.pa.us> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests= X-Spam-Level: X-Archive-Number: 200608/318 X-Sequence-Number: 20503 Tom Lane wrote: > What other planner parameters have you been fooling with? Hi Tom, The other parameters that have been changed are: set join_collapse_limit to 1 set enable_sort to off We are using version 8.1.3. We've noticed the query plan changing depending on the amount of data in the tables especially when the query looks at more rows in tableA. The parameter work_mem is set to 262,144. Thanks, Scott