X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 4FEC85E470C for ; Tue, 31 Aug 2004 17:26:13 -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 49614-08 for ; Tue, 31 Aug 2004 20:26:07 +0000 (GMT) Received: from mproxy.gmail.com (rproxy.gmail.com [64.233.170.207]) by svr1.postgresql.org (Postfix) with ESMTP id 72E175E46FB for ; Tue, 31 Aug 2004 17:26:03 -0300 (ADT) Received: by mproxy.gmail.com with SMTP id 73so192658rnk for ; Tue, 31 Aug 2004 13:26:05 -0700 (PDT) Received: by 10.38.76.16 with SMTP id y16mr1650726rna; Tue, 31 Aug 2004 13:26:05 -0700 (PDT) Received: by 10.38.86.41 with HTTP; Tue, 31 Aug 2004 13:26:05 -0700 (PDT) Message-ID: <4b09a0c040831132633b2bce5@mail.gmail.com> Date: Tue, 31 Aug 2004 22:26:05 +0200 From: Jean-Max Reymond Reply-To: Jean-Max Reymond To: Tom Lane Subject: Re: Optimizing a request Cc: pgsql-performance@postgresql.org In-Reply-To: <14630.1093983238@sss.pgh.pa.us> Mime-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit References: <4b09a0c0408311159fa91802@mail.gmail.com> <14630.1093983238@sss.pgh.pa.us> X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200408/485 X-Sequence-Number: 8121 On Tue, 31 Aug 2004 16:13:58 -0400, Tom Lane wrote: > That seems like a very strange plan choice given those estimated row > counts. I'd have expected it to use a nestloop with inner index scan > on article_rub_id_index. You haven't done anything odd like disable > nestloop, have you? > no optimizer disabled. > What plan do you get if you turn off enable_hashjoin? (If it's a merge > join, then turn off enable_mergejoin and try again.) Also, could we see > EXPLAIN ANALYZE not just EXPLAIN output for all these cases? > > regards, tom lane > OK, TOM Thanks for your help -- Jean-Max Reymond CKR Solutions http://www.ckr-solutions.com