Re: Partial index and query plan - Mailing list pgsql-sql

From Aleksandr Vinokurov
Subject Re: Partial index and query plan
Date
Msg-id b048c51b0708220732s5c4f9de0uc1f2c8ec521221d2@mail.gmail.com
Whole thread Raw
In response to Re: Partial index and query plan  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-sql
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.


pgsql-sql by date:

Previous
From: Tom Lane
Date:
Subject: Re: Partial index and query plan
Next
From: "Scott Marlowe"
Date:
Subject: Re: Partial index and query plan