Re: [PERFORM] Planner sometimes doesn't use a relevant index with IN (subquery) condition

* FROM (SELECT run_id, utilization FROM stats) AS s WHERE run_id = ANY(ARRAY(SELECT run_id FROM runs WHERE server_id = 515)); Thanks, On Sun, Nov 11, 2012 at 8:48 AM, Rafał Rzepecki divided.m...@gmail.com wrote: [Please CC me on replies, as I'm not subscribed; thank you.] I've ran

[PERFORM] Planner sometimes doesn't use a relevant index with IN (subquery) condition

relevant info I've ommited. (PostgreSQL 9.1.6 on x86_64-unknown-linux-gnu, compiled by gcc (Ubuntu/Linaro 4.7.2-2ubuntu1) 4.7.2, 64-bit running on Ubuntu 12.10, ubuntu package postgresql-9.1-9.1.6-1ubuntu1:amd64, default configuration) -- Rafał Rzepecki -- Sent via pgsql-performance mailing list