Postgres Pro
Downloads
Home   >   mailing lists

Re: [GENERAL] a JOIN to a VIEW seems slow - Mailing list pgsql-general

From Frank Millman
Subject Re: [GENERAL] a JOIN to a VIEW seems slow
Date
Msg-id FA8FE4E7E22B4A17813D05CECE30B0C5@FrankLaptop
Whole thread Raw
In response to Re: [GENERAL] a JOIN to a VIEW seems slow  (Merlin Moncure <mmoncure@gmail.com>)
List pgsql-general
Tree view
Merlin Moncure wrote:
On Thu, Sep 14, 2017 at 8:17 AM, Pavel Stehule <pavel.stehule@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

pgsql-general by date:

Previous
From: Merlin Moncure
Date:
Subject: Re: [GENERAL] a JOIN to a VIEW seems slow
Next
From: Job
Date:
Subject: [GENERAL] Multicolumn Index on OR conditions