Re: BUG #14107: Major query planner bug regarding subqueries and indices

From: Francisco Olarte <folarte(at)peoplecall(dot)com>
To: Victor Yegorov <vyegorov(at)gmail(dot)com>
Cc: Mathias Kunter <mathiaskunter(at)gmail(dot)com>, "pgsql-bugs(at)postgresql(dot)org" <pgsql-bugs(at)postgresql(dot)org>
Subject: Re: BUG #14107: Major query planner bug regarding subqueries and indices
Date: 2016-04-22 16:24:47
Message-ID: CA+bJJbyUF6CZPgH45JUdRRJ96qHMd31Fb-qHw0iN2aohRYMM6g@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

On Fri, Apr 22, 2016 at 4:14 PM, Victor Yegorov <vyegorov(at)gmail(dot)com> wrote:
>> EXPLAIN SELECT * FROM book WHERE name = 'Harry Potter' UNION SELECT * FROM
...
> Queries return different number of rows, meaning they're not fully
> equivalent.

IIRC plain-EXPLAIN returns estimates, you need explain analyze to be comparable.

Francisco Olarte.

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Victor Yegorov 2016-04-22 16:57:02 Re: BUG #14107: Major query planner bug regarding subqueries and indices
Previous Message Armando Perryman Morales 2016-04-22 15:30:12 problem installing postgres in debian8 from debian repository