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