Re: Add semi-join pushdown to postgres_fdw - Mailing list pgsql-hackers

From Alexander Pyhalov
Subject Re: Add semi-join pushdown to postgres_fdw
Date
Msg-id f929c315c6f3e9114ffc53e29fe83689@postgrespro.ru
Whole thread Raw
In response to Re: Add semi-join pushdown to postgres_fdw  (Tomas Vondra <tomas.vondra@enterprisedb.com>)
Responses Re: Add semi-join pushdown to postgres_fdw
List pgsql-hackers
Hi.

Tomas Vondra писал 2023-01-19 20:49:
> I took a quick look at the patch. It needs a rebase, although it 
> applies
> fine using patch.
> 
> A couple minor comments:
> 
> 1) addl_conds seems a bit hard to understand, I'd use either the full
> wording (additional_conds) or maybe extra_conds

Renamed to additional_conds.

> 
> 2) some of the lines got quite long, and need a wrap
Splitted some of them. Not sure if it's enough.

> 
> 3) unknown_subquery_rels name is a bit misleading - AFAIK it's the rels
> that can't be referenced from upper rels (per what the .h says). So 
> they
> are known, but hidden. Is there a better name?

Renamed to hidden_subquery_rels. These are rels, which can't be referred 
to from upper join levels.

> 
> 4) joinrel_target_ok() needs a better comment, explaining *when* the
> reltarget is safe for pushdown. The conditions are on the same row, but
> the project style is to break after '&&'.

Added comment. It seems to be a rephrasing of lower comment in 
joinrel_target_ok().

-- 
Best regards,
Alexander Pyhalov,
Postgres Professional
Attachment

pgsql-hackers by date:

Previous
From: shveta malik
Date:
Subject: Re: Time delayed LR (WAS Re: logical replication restrictions)
Next
From: shveta malik
Date:
Subject: Re: Time delayed LR (WAS Re: logical replication restrictions)