Re: Pathify RHS unique-ification for semijoin planning

Álvaro Herrera <alvherre@kurilemu.de>

From: Álvaro Herrera <alvherre@kurilemu.de>

To: Richard Guo <guofenglinux@gmail.com>

Cc: Pg Hackers <pgsql-hackers@lists.postgresql.org>

Date: 2025-08-12T15:58:24Z

Lists: pgsql-hackers

Commits

Same data as JSON: GET /api/v1/messages/:b64id/commits the thread's linked commits as JSON, with link sources. API reference →

Simplify relation_has_unique_index_for()
- bf9ee294e567 19 (unreleased) landed
Pathify RHS unique-ification for semijoin planning
- 24225ad9aafc 19 (unreleased) landed
Convert varatt.h access macros to static inline functions.
- e035863c9a04 19 (unreleased) cited
Re-export a few of createplan.c's make_xxx() functions.
- 570be1f73f38 9.6.0 cited

On 2025-Aug-12, Richard Guo wrote:

> Does anyone plan to review this patch further?  I intend to push it in
> two weeks unless there are any objections or additional comments.

No review, but apparently "uniquify" is more widely accepted than
"uniqueify".  No dictionary lists either words AFAICS, except that
Wiktionary lists the former:
https://en.wiktionary.org/wiki/uniquify
but apparently adjectives ending in "-e" are prone to lose it when a
verb is formed from them with "-ify", such as

https://www.merriam-webster.com/dictionary/falsify
https://www.merriam-webster.com/dictionary/intensify
https://www.merriam-webster.com/dictionary/simplify

There aren't many though.  Most in this list don't end in -e:
https://en.wiktionary.org/w/index.php?title=Category:English_terms_suffixed_with_-ify

-- 
Álvaro Herrera        Breisgau, Deutschland  —  https://www.EnterpriseDB.com/
"El destino baraja y nosotros jugamos" (A. Schopenhauer)