On Wed, Sep 14, 2011 at 6:50 AM, MirrorX <mirrorx@xxxxxxxxx> 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@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
