Re: union all and filter / index scan -> seq scan

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Florian Lohoff <f(at)zz(dot)de>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: union all and filter / index scan -> seq scan
Date: 2015-05-21 15:28:16
Message-ID: 27276.1432222096@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Florian Lohoff <f(at)zz(dot)de> writes:
> It seems the planner is not able to rewrite a union all

I do not see any problems with pushing indexable conditions down through a
UNION ALL when I try it. I speculate that either you are using a very old
9.1.x minor release, or the actual view is more complex than you've let on.

regards, tom lane

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Bosco Rama 2015-05-21 16:15:04 Re: Fastest way / best practice to calculate "next birthdays"
Previous Message Vitalii Tymchyshyn 2015-05-21 15:09:32 Re: union all and filter / index scan -> seq scan