Re: When can joins be avoided?

2022-11-17 Thread Tom Lane
Stefan Fehrenbach writes: > I'm interested in the rules that Postgres uses to avoid joins. Are > these documented somewhere? If I had to look at the source code, where > would I start? src/backend/optimizer/plan/analyzejoins.c > They don't seem to match my intuition about which joins > could be

When can joins be avoided?

2022-11-17 Thread Stefan Fehrenbach
Hey all! I'm interested in the rules that Postgres uses to avoid joins. Are these documented somewhere? If I had to look at the source code, where would I start? They don't seem to match my intuition about which joins could be avoided. Then again, it's quite possible that I'm wrong and misundersta