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 <[EMAIL PROTECTED]> wrote: > "Aleksandr Vinokurov" <[EMAIL PROTECTED]> 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. ---------------------------(end of broadcast)--------------------------- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq