Performance

GROUP BY vs DISTINCT

Every now and then I see queries that use GROUP BY without any aggregates which is the same as using DISTINCT instead.

Performance of stored functions

Something that users coming from other database systems easily overlook is, that Postgres supports different languages for writing stored functions (and procedures). Choosing the right language can influence the performance of your functions.