Re: [GENERAL] a JOIN to a VIEW seems slow

Поиск
Список
Период
Сортировка
От Frank Millman
Тема Re: [GENERAL] a JOIN to a VIEW seems slow
Дата
Msg-id FA8FE4E7E22B4A17813D05CECE30B0C5@FrankLaptop
обсуждение исходный текст
Ответ на Re: [GENERAL] a JOIN to a VIEW seems slow  (Merlin Moncure <mmoncure@gmail.com>)
Список pgsql-general
Дерево обсуждения
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 по дате отправления:

Предыдущее
От: Merlin Moncure
Дата:
Сообщение: Re: [GENERAL] a JOIN to a VIEW seems slow
Следующее
От: Job
Дата:
Сообщение: [GENERAL] Multicolumn Index on OR conditions