EXISTS vs IN vs JOIN — which is fastest?

Default to EXISTS when you need 'has at least one'. It is a semi-join and won't fan out. IN is fine on a small static list. Plain JOIN is for when you need columns from the right side; otherwise it risks duplicates.

On Postgres specifically the planner is good at rewriting IN and EXISTS to the same plan, so prefer the version that reads most clearly.