Postgres Pro
Downloads
Home   >   mailing lists

Re: union all and filter / index scan -> seq scan - Mailing list pgsql-performance

From Tom Lane
Subject Re: union all and filter / index scan -> seq scan
Date
Msg-id 27276.1432222096@sss.pgh.pa.us
Whole thread Raw
In response to union all and filter / index scan -> seq scan  (Florian Lohoff <f@zz.de>)
List pgsql-performance
Tree view 
Florian Lohoff <f@zz.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

pgsql-performance by date:

Previous
From: Vitalii Tymchyshyn
Date:
Subject: Re: union all and filter / index scan -> seq scan
Next
From: Bosco Rama
Date:
Subject: Re: Fastest way / best practice to calculate "next birthdays"