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

From: <kpi6288(at)gmail(dot)com>
To: <pgsql-general(at)postgresql(dot)org>
Subject: AW: CTE with JOIN of two tables is much faster than a regular query
Date: 2018-08-18 15:43:23
Message-ID: 006b01d4370a$3305b640$991122c0$@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

> -----Ursprüngliche Nachricht-----
> Von: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Prajilal KP 2018-08-18 16:07:51 Kerala Flood Relief - request to donate
Previous Message Tom Lane 2018-08-18 15:29:06 Re: CTE with JOIN of two tables is much faster than a regular query