No upcoming 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, ...

    @ Postgres Conference 2024

    Apr 17 2024

    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.

    @ South Africa 2018

    Oct 9 2018

    Operations and Administration

    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 ...

    @ South Africa 2018

    Oct 9 2018

    Operations and Administration

    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...

    @ PGConf Local: Seattle [PgConf.US]

    Nov 14 2017

    ops