Much faster to do it in the database than in the client, especially in a normal situation where the postgres server is on a different machine that's possibly not even in the same building as the app server or where it allows you to use existing indexes.

I agree that they're often a symptom of bad schema design or data normalisation though. Sometimes that can't be helped however.