Re: Correction of RowMark Removal During Sel-Join Elimination - Mailing list pgsql-hackers

From Greg Sabino Mullane
Subject Re: Correction of RowMark Removal During Sel-Join Elimination
Date
Msg-id CAKAnmmJzSGzTRaLATNZPErByO3-j6MwsK--qPSiRLJi4kB05HQ@mail.gmail.com
Whole thread Raw
In response to Correction of RowMark Removal During Sel-Join Elimination  (Andrei Lepikhov <lepihov@gmail.com>)
Responses Re: Correction of RowMark Removal During Sel-Join Elimination
List pgsql-hackers
Basic concept looks good. However:

and fixes the incorrect behaviour. Additionally, it renames variables to make
similar errors more apparent in the future.

- if (!innerrel_is_unique_ext(root, joinrelids, inner->relids,
- outer, JOIN_INNER, selfjoinquals,
+ if (!innerrel_is_unique_ext(root, joinrelids, rrel->relids,
+ krel, JOIN_INNER, selfjoinquals,

I'm not convinced this is an improvement from someone just coming in to this part of the code, especially given (for example) the comment right above it:

 * Determine if the inner table can duplicate outer rows.  We must
 * bypass the unique rel cache here since we're possibly using a


Cheers,
Greg

--
Enterprise Postgres Software Products & Tech Support

pgsql-hackers by date:

Previous
From: Robert Haas
Date:
Subject: Re: Extension security improvement: Add support for extensions with an owned schema
Next
From: Robert Haas
Date:
Subject: Re: ReplicationSlotRelease() crashes when the instance is in the single user mode