Analyze a situation, produce metrics, propose and evaluate solutions; whatever for skills or performances, it is in first place a work in collaboration with your teams.
Data structure is the first engaging step of a project. Real foundations, Postgresql's data type allow to combine several objectives: functionalities, performances, evolutivity.
A preliminary analysis of the business and the needs makes us able to determine the best compromise to set performances where there are necessary.
With or without ORM, performances problems are often the sign of a structural default or a misuse of the database. In order to determine the causes and propose accurate solutions, it is necessary to understand how the database is used. In most cases, it is possible to ship a fast and short term fix as cache allowing to request the incriminated part. A finest analyze leads to determine how to proceed in the long term.