Upcoming presentations
No upcoming presentations...
Past presentations
Amazon Aurora is a relational database service built for the cloud that provides unparalleled high performance and availability at global scale with full PostgreSQL compatibility. In this session, learn how Amazon Aurora Limitless Database enables applications to scale to millions of transactions per second across petabytes of data. Explore the architecture, distributed transaction management, ...
PostgreSQL 9.6 introduced wait events, and support was greatly enhanced in version 10. Simply put, wait events tell you why a query isn't making progress. This talk will cover how to monitor waits as well as the most common waits encountered and what they mean. Finally, we will introduce enhanced wait event monitoring available in Amazon's Aurora PostgreSQL.
All the dirt on VACUUM
How PostgreSQL Pays Its Debts
PostgreSQL is a debt-based system that pays for fast writes on credit. It's up to vacuum to pay the bills before it's too late.
Vacuum remains one of the most challenging and mysterious aspects of PostgreSQL. Most users know the why of vacuum but are fuzzy on the how. This session will be a deep dive into the internals of vacuum, its algorithms, and includes a discussion of how ...
In this session we will cover a number of the way that you can tune PostgreSQL to better handle high write workloads. We will cover both application and database tuning methods as each type can have substantial benefits but can also interact in unexpected ways when you are operating at scale. On the application side we will look at write batching, use of GUID's, general index structure, the c...