On 6/19/2015 10:46 AM, Igor Neyman wrote:
Probably events_confidnce index is not very selective, that's why optimizer
prefers seq scan.
I'd try to create an index on (name, eventspy_id, camera_id, type, status).
Also, the recent 9.2 is 9.2.13, you should upgrade.
Regards,
Igor Neyman
Hi Igor,
I already have an index for (name, eventspy_id, camera_id, type,
status)... that is the index being used (apparently silently) when I set
random_page_cost=1.0.
Thanks,
-Ian
--
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance
