Merlin Moncure wrote:
On Thu, Sep 14, 2017 at 8:17 AM, Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com> wrote:
>
> >
> > The PostgreSQL cannot to push join - in slow case, the UNIONS should be done
> > first - and it requires full scan ar_tran_inv - used filter (posted AND
> > (deleted_id = 0) is not too effective - maybe some composite or partial
> > index helps.
>
> In my testing JOINS can push through UNION ALL. Why do we need to
> materialize union first? What version is this?
>
I am using version 9.4.4 on Fedora 22.
Frank Millman