AW: CTE with JOIN of two tables is much faster than a regular query

Поиск
Список
Период
Сортировка
От
Тема AW: CTE with JOIN of two tables is much faster than a regular query
Дата
Msg-id 006b01d4370a$3305b640$991122c0$@gmail.com
обсуждение исходный текст
Ответ на Re: CTE with JOIN of two tables is much faster than a regular query  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-general
Дерево обсуждения 
> -----Ursprüngliche Nachricht-----
> Von: Tom Lane <tgl@sss.pgh.pa.us>
> Gesendet: Samstag, 18. August 2018 17:29
>
> Well, it's simpler than that: filter quals are always evaluated at the
lowest
> possible plan level.

Thank you. This "always" was not clear to me, but it explains a few similar
cases (with not-so-extreme differences) that I could not understand.

Regards
Klaus

В списке pgsql-general по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: CTE with JOIN of two tables is much faster than a regular query
Следующее
От: Prajilal KP
Дата:
Сообщение: Kerala Flood Relief - request to donate