Robert Haas writes:
> On Sat, Mar 3, 2012 at 10:03 PM, Tom Lane wrote:
>> Sooner or later I'd like to relax the restriction that appendrel members
>> can't have extra WHERE clauses, but don't hold your breath waiting...
> Does this comment need updating?
> * Note: the data structure assumes th
On Sat, Mar 3, 2012 at 10:03 PM, Tom Lane wrote:
> Claus Stadler writes:
>> Query optimizer glitch: "...WHERE TRUE" condition in union results in
>> bad query plan ...
>
> Yeah, this is because a nonempty WHERE clause defeats simplifying the
> UNION ALL into a simple "append relation" (cf is_safe
Claus Stadler writes:
> Query optimizer glitch: "...WHERE TRUE" condition in union results in
> bad query plan ...
Yeah, this is because a nonempty WHERE clause defeats simplifying the
UNION ALL into a simple "append relation" (cf is_safe_append_member()).
The planner will eventually figure out
Hi,
(Sorry about double post, I just registered on the performance mailing
list, but sent the mail from the wrong account - if anyone responds,
please respond to this address)
Another issue I have encountered :)
Query optimizer glitch: "...WHERE TRUE" condition in union results in
bad query
