Normalization is about the relationship between entities.
Joins is about using that relationship to narrow down the result when querying.
You could still have a normalized database, but perform queries without using joins for extra speed.
You will get it, but at a cost elsewhere. (e.g you have to write code in your application that puts data from multiple queries together).
Personally, I would try all possible optimization technics first (wiki.postgresql.org/wiki/Performan...) before avoiding joins. There's a lot of them. Also, high-performance hardware should be considered too.
I see, that make sense, thank you
We're a place where coders share, stay up-to-date and grow their careers.
We strive for transparency and don't collect excess data.