Doc: note that two examples in optimizer/README are oversimplified.
authorTom Lane <tgl@sss.pgh.pa.us>
Wed, 9 Apr 2025 03:03:33 +0000 (23:03 -0400)
committerTom Lane <tgl@sss.pgh.pa.us>
Wed, 9 Apr 2025 03:03:33 +0000 (23:03 -0400)
commitdd496eedeaac7cc9023e8fbca709475868ed5d9a
tree014bbe9f8b1d8fe14495324d5e910e608887a032
parentb65b9da568fd93f8fe3b41f4074f225eead104d2
Doc: note that two examples in optimizer/README are oversimplified.

These examples fail to account for join clauses generated by
EquivalenceClasses, but since we haven't mentioned EquivalenceClasses
yet it seems like it'd just add confusion to make them fully accurate.
Instead, parenthetically note that they're oversimplified.

Reported-by: Zeyuan Hu <ferrishu3886@gmail.com>
Co-authored-by: David Rowley <dgrowleyml@gmail.com>
Co-authored-by: Tom Lane <tgl@sss.pgh.pa.us>
Discussion: https://postgr.es/m/CACvHWmYFo+60yMqKJajDDvKN5EM41YHrCT3oxukwXmGAqpWvyw@mail.gmail.com
src/backend/optimizer/README