Postgres Pro
Downloads
Home   >   mailing lists

Re: query plan and the use of indexes - Mailing list pgsql-novice

From Tom Lane
Subject Re: query plan and the use of indexes
Date
Msg-id 9746.1181572505@sss.pgh.pa.us
Whole thread Raw
In response to query plan and the use of indexes  ("David Monarchi" <david.e.monarchi@gmail.com>)
List pgsql-novice
Tree view 
"David Monarchi" <david.e.monarchi@gmail.com> writes:
> I don't understand why the use of a single inequality ( > or < ) causes the
> planner to filter on the condition, but the use of an interval (> and <)
> causes the planner to use the index.

There's something awfully wacko about the rowcount estimates you're
getting.  What PG version are you using?  I think you may be getting
bit by the recently-fixed bugs in choose_bitmap_and() ...

            regards, tom lane

pgsql-novice by date:

Previous
From: "David Monarchi"
Date:
Subject: query plan and the use of indexes
Next
From: "Gary Townsend"
Date:
Subject: Re: PGPLSql Select Into problem.