Received: from maia.hub.org (maia-5.hub.org [200.46.204.29]) by mail.postgresql.org (Postfix) with ESMTP id B4DEF632EE5 for ; Wed, 28 Jul 2010 07:49:45 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.29]) (amavisd-maia, port 10024) with ESMTP id 30022-07 for ; Wed, 28 Jul 2010 10:49:38 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from mail.anarazel.de (mail.anarazel.de [217.115.131.40]) by mail.postgresql.org (Postfix) with ESMTP id 81C28632A4A for ; Wed, 28 Jul 2010 07:49:38 -0300 (ADT) Received: from alap2.localnet (p579FB2CD.dip.t-dialin.net [87.159.178.205]) by mail.anarazel.de (Postfix) with ESMTPSA id 22673448005; Wed, 28 Jul 2010 12:49:36 +0200 (CEST) From: Andres Freund To: pgsql-performance@postgresql.org Subject: Re: 158x query improvement when removing 2 (noop) WHERE conditions Date: Wed, 28 Jul 2010 12:49:34 +0200 User-Agent: KMail/1.13.5 (Linux/2.6.35-rc4-andres; KDE/4.4.92; x86_64; ; ) Cc: "Louis-David Mitterrand" References: <20100728102744.GA18521@apartia.fr> In-Reply-To: <20100728102744.GA18521@apartia.fr> MIME-Version: 1.0 Content-Type: Text/Plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit Message-Id: <201007281249.34573.andres@anarazel.de> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.79 tagged_above=-10 required=5 tests=BAYES_50=0.8, T_RP_MATCHES_RCVD=-0.01 X-Spam-Level: X-Archive-Number: 201007/429 X-Sequence-Number: 39818 On Wednesday 28 July 2010 12:27:44 Louis-David Mitterrand wrote: > The EXPLAIN ANALYSE output is attached with, first the fast version and > then the slow one. I think you forgot to attach it. Andres