Re: [PERFORM] Odd behavior with indices

Matheus de Oliveira writes: > Em 26 de fev de 2016 4:44 PM, "joe meiring" > escreveu: >> The same query for parameters is rather slow and does NOT use the index: >> >> EXPLAIN ANALYZE >> select * >> from parameter >> where exists ( >> select 1 from datavalue >> where datavalue.parameter_id = par

Re: [PERFORM] Merge joins on index scans

David Rowley writes: > On 27 February 2016 at 11:07, James Parks wrote: >> If you force the query planner to use a merge join on the above query, it >> takes 10+ minutes to complete using the data as per below. If you force the >> query planner to use a hash join on the same data, it takes ~200 >