From: Aleksandr Vinokurov <aleksandr.vin@gmail.com>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: pgsql-sql@postgresql.org
Subject: Re: Partial index and query plan
Date: Wed, 22 Aug 2007 18:32:03 +0400
Message-ID: <b048c51b0708220732s5c4f9de0uc1f2c8ec521221d2@mail.gmail.com> (raw)
In-Reply-To: <7099.1187791844@sss.pgh.pa.us>
References: <b048c51b0708220557g18cc9a6p7bf2ab195539c3bd@mail.gmail.com>
<7099.1187791844@sss.pgh.pa.us>
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 <tgl@sss.pgh.pa.us> wrote:
> "Aleksandr Vinokurov" <aleksandr.vin@gmail.com> 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.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: aleksandr.vin@gmail.com, tgl@sss.pgh.pa.us
Subject: Re: Partial index and query plan
In-Reply-To: <b048c51b0708220732s5c4f9de0uc1f2c8ec521221d2@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox