On Wed, Sep 14, 2011 at 6:50 AM, MirrorX <mirrorx(at)gmail(dot)com> wrote:
> any ideas on how i should write to query to use this index? thx in advance
You can do something like:
set enable_seqscan=off;
explain select yourqueryhere;
and see if the plan it comes up with is any better. Use explain
analyze to see how long it really takes. Basically if the index isn't
selective enough a seq scan will be a win, especially in pgsql where
it has to hit the table anyway, whether it uses the index or not.