Postgres Pro
Downloads
Home   >   mailing lists

Re: Postgres not using indices defined on my table with certain queries using "in" - Mailing list pgsql-novice

From Tom Lane
Subject Re: Postgres not using indices defined on my table with certain queries using "in"
Date
Msg-id 3473.1183608503@sss.pgh.pa.us
Whole thread Raw
In response to Postgres not using indices defined on my table with certain queries using "in"  ("s anwar" <sanwar@gmail.com>)
Responses Re: Postgres not using indices defined on my table with certain queries using "in"
List pgsql-novice
Tree view 
"s anwar" <sanwar@gmail.com> writes:
> The two queries blow require radically different query times 1600ms vs 10ms:

Try not to be so fancy with a bunch of somewhat-overlapping partial indexes.
The planner is not so smart as you, and will not always be able to prove
to itself that it can use these indexes.  A single, non-partial index on
ock would perform at least as well as this hodgepodge.

            regards, tom lane

pgsql-novice by date:

Previous
From: "s anwar"
Date:
Subject: Postgres not using indices defined on my table with certain queries using "in"
Next
From: mike lane
Date:
Subject: how to get pg_dump in postgesql 8.2 to create inserts with E'....' for back slashes