Postgres Pro
Downloads
Home   >   mailing lists

AW: CTE with JOIN of two tables is much faster than a regular query - Mailing list pgsql-general

From
Subject AW: CTE with JOIN of two tables is much faster than a regular query
Date
Msg-id 006b01d4370a$3305b640$991122c0$@gmail.com
Whole thread Raw
In response to Re: CTE with JOIN of two tables is much faster than a regular query  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
Tree view 
> -----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 by date:

Previous
From: Tom Lane
Date:
Subject: Re: CTE with JOIN of two tables is much faster than a regular query
Next
From: Prajilal KP
Date:
Subject: Kerala Flood Relief - request to donate