Bio

Mohsin Ejaz is a Senior DevOps Engineer with 19 years of experience in the PostgreSQL ecosystem, including 17 years at EnterpriseDB (EDB). His work focuses on containerization, CI/CD automation, and database infrastructure.

Currently, he works at DBtune, an AI-powered database optimization company, where he helps organizations improve PostgreSQL performance and reduce cloud costs. In addition to DevOps and benchmarking work, he collaborates closely with customers during technical engagements, translating complex performance data into practical optimization strategies. He also shares insights from real-world tuning challenges through blogs and conference talks.

Talk Description: Why your PostgreSQL tuning guide might be wrong (and what to do about it)

Have you ever applied PostgreSQL performance tuning advice only to see no improvement—or made things worse? While generic PostgreSQL wisdom is valuable, the complexity of PostgreSQL makes catch-all solutions underperform in unexpected ways.

I will share examples where one PostgreSQL configuration improved performance in one system but hurt it in another—even for the same workload. The key insight: optimal PostgreSQL server parameters depend heavily on your specific infrastructure characteristics. I'll present a checklist of important infrastructure differences—local vs network storage, IOPS limits, JIT availability, cloud vs on-premise—and demonstrate how these different environments require different optimal configurations for the same workload.

You'll leave understanding why generic tuning guides often fail and what infrastructure characteristics you need to consider when tuning YOUR specific PostgreSQL system.