Re: Index non-usage problem in 8.2.9 - Mailing list pgsql-general

From Joseph S
Subject Re: Index non-usage problem in 8.2.9
Date
Msg-id 48BE09AD.8000302@selectacast.net
Whole thread Raw
In response to Index non-usage problem in 8.2.9  (Joseph S <jks@selectacast.net>)
Responses Re: Index non-usage problem in 8.2.9
List pgsql-general

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.

pgsql-general by date:

Previous
From: Joseph S
Date:
Subject: Re: Index non-usage problem in 8.2.9
Next
From: Tom Lane
Date:
Subject: Re: Index non-usage problem in 8.2.9