Postgres Pro
Downloads
Home   >   mailing lists

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

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

pgsql-sql by date:

Previous
From: "Christian Kindler"
Date:
Subject: Re: Solution to retrieve first and last row for each minute
Next
From: "Aleksandr Vinokurov"
Date:
Subject: Re: Partial index and query plan