Denormalize with Care

We denormalize our application’s schema when we know what we’re doing and when we’ve double-checked that there’s no other possibility for implementing your application and business cases with the required level of performance.

Know when to denormalize your database

First, query optimization techniques—mainly rewriting until it’s obvious for PostgreSQL how to best execute a query—can go a long way. Production examples of query rewrites improving durations from minutes to milliseconds are commonly achieved, in particular against queries written by ORMs or other naïve toolings.