Thanks for the reply, Brice.
Brice André wrote
> - If your test DB has so few data that it is not efficient to use the
> index, this last will not be used. You should probably try to insert
> more
> data before performing the test
> - the query planner uses table statistics to decide if it uses an
> index.
> But, if those statistics are not up-to-date, the choice can be not
> optimal.
> You should maybe try to look at 'Analyse' command to get more info :
As I said, the data in my production env is populated but I'm getting the
same results, even after running ANALYZE on the tables.
--
View this message in context: http://postgresql.nabble.com/View-not-using-index-tp5865953p5866097.html
Sent from the PostgreSQL - sql mailing list archive at Nabble.com.
