Joseph S <[EMAIL PROTECTED]> writes:
> Tom Lane wrote:
>> Can you force it to use the partial index by dropping the other index?
>> (Use begin; drop index ...; explain ...; rollback; to avoid dropping
>> the index for real.) It's quite unclear at this point whether it
> I tried, and it ends up using a seqscan.
Just to be sure, what if you set enable_seqscan = off?
If still not, then there must be something about the table or index
declaration that you didn't tell us. In the past, issues like use of
a domain instead of a bare datatype have been relevant ...
regards, tom lane
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
