• Hector Villarreal Ortega
• 5 minutes reading
• 21 May, 2026
• • PostgreSQL
  • Performance
  • Odoo
  • ERP
  • Database

PostgreSQL Query Optimization for ERP Scale

ERP databases are not slow by accident. They are slow because the same patterns that make ORMs productive — automatic joins, lazy loading, computed field resolution — scale poorly against tables with millions of rows and multi-company filtering. The fix is not to abandon the ORM. The fix is to understand exactly where it breaks down.

Read more

• Hector Villarreal Ortega
• 5 minutes reading
• 21 May, 2026
• • Docker
  • DevOps
  • Infrastructure
  • Odoo
  • PostgreSQL

Docker Compose for Real ERP Environments

Docker Compose is sometimes dismissed as a development-only tool. For many small and medium ERP teams, it can be much more useful than that when it is applied with discipline.

Read more

• Hector Villarreal Ortega
• 5 minutes reading
• 21 May, 2026
• • Performance
  • Python
  • APM
  • PostgreSQL
  • E-commerce

Reducing an E-commerce API from 10s to Under 1s

Performance work starts with humility. When an API endpoint takes around 10 seconds, the first instinct is often to rewrite the obvious function. That is rarely the best first move.

Read more