Many teams running Odoo on PostgreSQL keep slow queries in check with a safety net, such as a cron job that kills anything running longer than three minutes. It keeps the system online, but it also hides the problems underneath, so reports stop finishing, bulk deletes run for hours and temporary files keep piling up.
Join Umair Shahid, Founder & CEO at Stormatics, on 25 November, 2026 at 3:00 pm GMT for a session on rescuing a high-volume production Odoo workload on PostgreSQL. Drawing on a real engagement where a query-killing cron job was masking serious performance problems, Umair will walk through how the team stabilised the system first with resource right-sizing and parameter tuning, then used several days of pg_gather measurement against production traffic to find the root causes, cutting report times from over 30 minutes to under 2.

→ Why safety mechanisms like query-killing cron jobs hide performance problems instead of fixing them
→ How to stabilise a struggling production system first, with resource right-sizing and parameter tuning
→ Using pg_gather to measure production traffic over several days and find the real bottlenecks
→ How missing foreign key indexes on nine transactional tables were slowing down Odoo's reports and deletes
→ Building a targeted indexing strategy and measuring its impact
→ Measuring urgently to stabilise, and patiently to find the root cause
This webinar is especially relevant for DBAs, platform engineers and engineering leads running Odoo or other ORM-heavy applications on PostgreSQL in production. It is particularly useful for teams that rely on timeouts or scheduled jobs to keep slow queries in check, or that are seeing reports, batch jobs and bulk operations slow down as their data grows.
Umair Shahid is the Founder & CEO of Stormatics, a specialist database services firm built to Elevate PostgreSQL in production. He works with fintechs, SaaS companies, and enterprises to design and run production-grade systems: resilient architectures, performance under load, security hardening, and migrations from proprietary databases across cloud and on-prem environments.
With more than two decades in the ecosystem, Umair is a subject matter expert who is regularly invited to speak at industry conferences. He publishes practical blogs and benchmark-driven white papers reaching more than 15,000 readers each month.