Over-normalising can kill perf, yeah. But under-normalising? That’s tech debt waiting to happen.
I’d say:
- Normalise first, optimise later.
- Use indexes wisely.
- Cache heavy queries.
Reddit’s r/Database has solid threads on this. Also, PostgreSQL docs explain normalisation of data really well.
I’d say:
- Normalise first, optimise later.
- Use indexes wisely.
- Cache heavy queries.
Reddit’s r/Database has solid threads on this. Also, PostgreSQL docs explain normalisation of data really well.