From: | "Aleksandr Vinokurov" <aleksandr(dot)vin(at)gmail(dot)com> |
---|---|
To: | "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | pgsql-sql(at)postgresql(dot)org |
Subject: | Re: Partial index and query plan |
Date: | 2007-08-22 14:32:03 |
Message-ID: | b048c51b0708220732s5c4f9de0uc1f2c8ec521221d2@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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(at)sss(dot)pgh(dot)pa(dot)us> wrote:
> "Aleksandr Vinokurov" <aleksandr(dot)vin(at)gmail(dot)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.
From | Date | Subject | |
---|---|---|---|
Next Message | Scott Marlowe | 2007-08-22 14:43:00 | Re: Partial index and query plan |
Previous Message | Tom Lane | 2007-08-22 14:10:44 | Re: Partial index and query plan |