Interesting article that goes through some performance analysis of PostgreSQL joins to question the idea that joins are expensive:
Interesting article that goes through some performance analysis of PostgreSQL joins to question the idea that joins are expensive: