...

/

Premature Optimization and Functional Dependency Trade-Offs

Premature Optimization and Functional Dependency Trade-Offs

Learn about premature optimization and functional dependency trade-offs in PostgreSQL.

Premature optimization

The CSV-model anti-pattern database modeling makes it easy to fall into the trap of premature optimization. Only use denormalization techniques when you’ve made a strong case for needing them.

A strong case means we’ve benchmarked our application code against our real production data or a dataset that ...