Scaling PostgreSQL: Vertical, Horizontal, and High Availability Strategies

Schedule

Presented by:

Dr. Ibrar Ahmed

pgEdge

Ibrar Ahmed, Principal Engineer at pgEdge, brings 25 years of experience in software design and open-source development, particularly PostgreSQL. With a strong background in system-level embedded development, Ibrar has made impactful contributions during his tenure at companies like EnterpriseDB, Percona, and Bitnine. Since 2006, he's been instrumental in enhancing PostgreSQL's core engine, driving performance improvements, and refining essential modules.

His expertise spans MySQL, Oracle, and NoSQL solutions like MongoDB and Hadoop, alongside tools like Hive, HBase, and Spark. A prolific author and blogger, Ibrar shares deep insights into PostgreSQL with several authoritative books. Over the past year, he’s delivered over fifteen talks worldwide at PostgreSQL conferences, further cementing his reputation. His dedication to advancing data management technology continues to shape the PostgreSQL landscape.

No video of the event yet, sorry!

Postgres is recognized for its flexibility—but scaling it efficiently takes more than just throwing hardware at the problem. In this technical session, we’ll break down how to approach Postgres scaling holistically, combining vertical + horizontal strategies with high availability to meet modern workload demands. You'll learn:

  • How to optimize vertical scaling with Postgres configuration parameters like shared_buffers, work_mem, and effective_cache_size
  • Techniques for horizontal scaling: streaming vs. logical replication, sharding, and partitioning
  • Tools and patterns for high availability, including automatic failover, connection pooling, and backup best practice
  • Why combining vertical + horizontal scaling yields the best results for performance, stability, and resilience

Whether you're managing a single high-performance instance or building out a multi-node cluster, this session will help you scale Postgres the right way—without compromising on availability or speed. Reserve your spot now and learn how to keep Postgres fast, available, and ready for growth.

Date:
Duration:
50 min
Room:
Conference:
2025 Postgres World Webinar Series
Language:
Track:
Ops
Difficulty:
Easy
Requires Registration:
Yes (Registered: 49)