Received: from localhost (maia-1.hub.org [200.46.204.191]) by postgresql.org (Postfix) with ESMTP id 7A8629F987D for ; Wed, 22 Aug 2007 11:32:08 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.191]) (amavisd-maia, port 10024) with ESMTP id 63443-01-10 for ; Wed, 22 Aug 2007 11:32:05 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.5 Received: from rv-out-0910.google.com (rv-out-0910.google.com [209.85.198.185]) by postgresql.org (Postfix) with ESMTP id 542F29F984F for ; Wed, 22 Aug 2007 11:32:05 -0300 (ADT) Received: by rv-out-0910.google.com with SMTP id c24so128244rvf for ; Wed, 22 Aug 2007 07:32:03 -0700 (PDT) DKIM-Signature: a=rsa-sha1; c=relaxed/relaxed; d=gmail.com; s=beta; h=domainkey-signature:received:received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=nLVcQuk9O+uARO/Y4CkLAGthK1zpta2IZUMj5EpH3U/UDiAV97LJKKiapDR0W3kxd32CmSw70QVKmG6Q9bK2MDXOcueylKF4/tlUwNJk+gWAa6VToea6G0hbMvpCNS5biXuIHjcHgkHEUnlaCTF5EDbDYIbXZ7La0HgUl0/H8kw= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta; h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=QzRT/y1VSOAfhFPfZRct4CZQw3sRnfkpZVfdmx2Q+51w7KRtSW++LnzbnQFJl/hekTQXNUkkzawuV6w8vq9YKAp4bUv84sFbYbj1HVLkplnfAwtbT4XgRsn3hfgKVxT7wjYFtn1QCX5xe5ieDvecwW0P6XtqicGZQ7PssA6Ql+8= Received: by 10.140.201.1 with SMTP id y1mr306856rvf.1187793123348; Wed, 22 Aug 2007 07:32:03 -0700 (PDT) Received: by 10.140.194.12 with HTTP; Wed, 22 Aug 2007 07:32:03 -0700 (PDT) Message-ID: Date: Wed, 22 Aug 2007 18:32:03 +0400 From: "Aleksandr Vinokurov" To: "Tom Lane" Subject: Re: Partial index and query plan Cc: pgsql-sql@postgresql.org In-Reply-To: <7099.1187791844@sss.pgh.pa.us> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline References: <7099.1187791844@sss.pgh.pa.us> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200708/197 X-Sequence-Number: 29135 Thank you Tom, but does it means that this is only an explain's problem or the plan is actually such a hard, and postmaster actually checks each record found by the index with this "filter"? I'm using 8.0.1 version, but upgrading can become a work with expense. On 22/08/07, Tom Lane wrote: > "Aleksandr Vinokurov" writes: > > The question is why "explain analyze" shows a 'Filter: ("action" <> 0)' in plan: > > Use a newer Postgres release (8.1 or later). > > regards, tom lane > With best wishes, Aleksandr.