Re: Postgres not using indices defined on my table with certain queries using "in"

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
(view: Whole thread, Raw)
In response to: Postgres not using indices defined on my table with certain queries using "in"  ("s anwar")
Responses: Re: Postgres not using indices defined on my table with certain queries using "in"  ("s anwar")
List: pgsql-novice


"s anwar" <> 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:

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