| From: | gmb <gmbouwer(at)gmail(dot)com> |
|---|---|
| To: | pgsql-sql(at)postgresql(dot)org |
| Subject: | Re: View not using index |
| Date: | 2015-09-16 04:45:44 |
| Message-ID: | 1442378744681-5866097.post@n5.nabble.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | dave | 2015-09-20 11:12:36 | Recursive merging of overlapping arrays in a column |
| Previous Message | Igor Neyman | 2015-09-15 13:29:09 | Re: View not using index |