Re: BUG #14107: Major query planner bug regarding subqueries and indices - Mailing list pgsql-bugs

From Francisco Olarte
Subject Re: BUG #14107: Major query planner bug regarding subqueries and indices
Date
Msg-id CA+bJJbyUF6CZPgH45JUdRRJ96qHMd31Fb-qHw0iN2aohRYMM6g@mail.gmail.com
Whole thread Raw
In response to Re: BUG #14107: Major query planner bug regarding subqueries and indices  (Victor Yegorov <vyegorov@gmail.com>)
Responses Re: BUG #14107: Major query planner bug regarding subqueries and indices
List pgsql-bugs
On Fri, Apr 22, 2016 at 4:14 PM, Victor Yegorov <vyegorov@gmail.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.

pgsql-bugs by date:

Previous
From: Victor Yegorov
Date:
Subject: Re: BUG #14107: Major query planner bug regarding subqueries and indices
Next
From: Victor Yegorov
Date:
Subject: Re: BUG #14107: Major query planner bug regarding subqueries and indices