Webinar | Improving Postgres Performance with Partitioning

Partitioning in Postgres plays a critical role in scalability, query performance, and cost efficiency. When applied correctly, partitioning can speed up queries, reduce storage overhead, simplify maintenance, and prevent bottlenecks, making your Postgres database more efficient and easier to manage.

On 23 April 2025 at 3 PM GMT, Umair Shahid, Founder at Stormatics, led a focused session breaking down the core types of partitioning in Postgres. Attendees learned how to select the right partitioning method and how each strategy affects performance, storage design, and operational efficiency.

Following topics will be covered in the session:

  • Beyond data organization: How partitioning improves performance, scalability, and cost efficiency
  • Range vs. Hash vs. List partitioning: Choosing the right approach for different workloads
  • Performance Gains: Reducing query execution time and optimizing indexing
  • Storage and Maintenance Benefits: Simplifying backups, archiving, and data retention
  • Cost Optimization: Decreasing cloud expenses with smarter partition structures
  • Real-world case studies: Overview of successful partitioning strategies driving long-term efficiency and performance 

Who should watch?

DBAs and engineers looking to build fast and scalable databases. Tech leads and CTOs focused on reducing costs and optimizing Postgres infrastructure.

About the Speaker

Umair Shahid

Founder, Stormatics

Umair is a trusted expert in the Postgres community with 20 years of experience, renowned for sharing innovative ideas and leading advancements in database solutions. He helps businesses make their databases fast, reliable, and cost-efficient.  With Postgres, he ensures your data is safe, your system runs smoothly, and everything grows as your business grows.

At Stormatics, Umair leads a talented team that solves complex problems, secures databases, and enhances their performance. Recognizing that every business is unique, the company creates tailored solutions to meet specific needs, whether it is making things faster, stronger, or ready for the future.

Umair shares his expertise at international conferences, through webinars, and in training sessions, empowering others to tackle challenging Postgres issues. His previous experience with commercial Postgres has spanned roles related to professional services and product management in major pure-play Postgres organizations like EDB, 2ndQuadrant, OpenSCG, & Percona

 

Watch the recording