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

2012-11-11 Thread Rafał Rzepecki
ow subtly changing the semantics of the query and don't notice? I understand the planner perhaps tries to parallelize queries when a SELECT is used in the IN clause, but given the stats it doesn't seem to make much sense. Thanks, and let me know if you want me to test something on

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

2012-11-12 Thread Rafał Rzepecki
his: > > > SELECT * 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 > wrote: >> >> [Please CC me on replies, as I'