On 6/19/2015 10:47 AM, Andreas Kretschmer wrote:
Explain Analyze outputs (links as requested):
Default plan: http://explain.depesz.com/s/ib3k
Forced index (random_page_cost=1.0): http://explain.depesz.com/s/lYaP
Software/Hardware: PGSql 9.2.1, Windows 8.1, 8GB RAM
All pgsql settings are at the
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 I
):
Default plan: http://explain.depesz.com/s/ib3k
Forced index (random_page_cost=1.0): http://explain.depesz.com/s/lYaP
Software/Hardware: PGSql 9.2.1, Windows 8.1, 8GB RAM
All pgsql settings are at their defaults.
Thanks for any help you can provide,
-Ian Pushee
--
Sent via pgsql-performance
