PostgreSQL Troubleshooting in the Real World hosted by Cloud Austin
Details
Attention Austin Postgres Meetup members! We are collaborating again with Cloud Austin for the relaunch of our in-person hosted events for Austin Postgres in advance of Austin Tech Week!
This month's Cloud Austin Meetup will be hosted at ECS Region 13, the new home for Cloud Austin!
Our speaker, Umair Shahid from Stormatics, has recently joined the local organizing team for the Austin Postgres User Group. This talk was just presented at Postgres Summit US!
---
Killing the Cron Job: Rescuing a Production Odoo Workload on PostgreSQL
When we walked in, every query running longer than three minutes was being killed by a cron job. That cron job was the only thing keeping the system standing, and it was hiding everything that was actually broken.
Core financial reports were taking over thirty minutes to run, most of them never finishing. CPU was pinned, IOPS were spiking, and bulk delete operations on operational tables were taking more than two hours.
This talk walks through the effort on a high-volume Odoo deployment, with the actual numbers from the engagement.
Learn more about the Lessons Learned: how the symptoms were being addressed but not the root cause of their performance problem, and what was done to observe, analyze, and resolve the issues once and for all.
---
Umair Shahid is the founder 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.
****************
NOTE: To help Cloud Austin keep manage seating as well as food and refreshments, Please RSVP at the Cloud Austin event link at https://www.meetup.com/cloudaustin/events/312511537/
****************
We hope that you can also join us in-person later in the week on Thursday, Oct 22 · 5:30 PM to 7:30 PM CDT for our official Austin Postgres event, "AI-use for Postgres: Simple and Safe" presented by long-time PostgreSQL community member Tatiana Krupenya sharing insights on "AI-use for Postgres: simple and safe." Check the event page for more details and how to register.