On Wed, Sep 14, 2011 at 6:50 AM, MirrorX <mirr...@gmail.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. -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
