Re: Partial index and query plan

Поиск
Список
Период
Сортировка
От Aleksandr Vinokurov
Тема Re: Partial index and query plan
Дата
Msg-id b048c51b0708220732s5c4f9de0uc1f2c8ec521221d2@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Partial index and query plan  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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 по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Partial index and query plan
Следующее
От: "Scott Marlowe"
Дата:
Сообщение: Re: Partial index and query plan