Schedule - PGConf NYC 2023

Scaling PostgreSQL for High-Traffic Applications: Architectural Patterns and Best Practices

Date: 2023-10-05
Time: 14:00–14:50
Room: The Forum
Level: Intermediate
Feedback: Leave feedback

In today's digital landscape, high-traffic applications demand robust and scalable database solutions. PostgreSQL, with its rich feature set and extensibility, is an excellent choice for such applications. This talk will delve into the intricacies of scaling PostgreSQL to handle the challenges posed by high-traffic workloads. We will explore architectural patterns and best practices that can empower your applications to handle increasing user demands without compromising on performance or data integrity. During this session, we will discuss various strategies for scaling PostgreSQL, including horizontal and vertical scaling, sharding, replication, and connection pooling. We will delve into the pros and cons of each approach and explore real-world use cases where these techniques have been successfully employed. Additionally, we will explore advanced caching strategies, query optimization techniques, and hardware considerations that can further enhance the performance and scalability of your PostgreSQL deployments. By attending this session, you will gain valuable insights into the world of scaling PostgreSQL for high-traffic applications. Whether you are a developer, architect, or database administrator, this talk will equip you with the knowledge and best practices necessary to design and implement a scalable and performant database architecture for your mission-critical applications. Join us to unlock the power of PostgreSQL and ensure your applications can handle the demands of the modern digital landscape with ease.


Vibhor Kumar