Merlin Moncure wrote: On Thu, Sep 14, 2017 at 8:17 AM, Pavel Stehule <pavel.steh...@gmail.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
