Cool! Thanks for the speedy reply, link, and summary! I'm not sure how I
missed this, but apologies for the noise.
-Paul-
On Thu, Jul 11, 2024 at 4:49 PM Andrei Lepikhov wrote:
> On 12/7/2024 06:31, Paul George wrote:
> > In the example below, I noticed that the JOIN predicate &
Hey!
[version: PostgreSQL 16.3]
In the example below, I noticed that the JOIN predicate "t1.a<1" is not
pushed down to the scan over "t2", though it superficially seems like it
should be.
create table t as (select 1 a);
analyze t;
explain (costs off) select * from t t1 join t t2 on t1.a=t2.a and
