No upcoming presentations...

    This talk will first introduce the different ways PostgreSQL can use memory, from the operating system, to cluster wide and then into per session and per operation. From there we will dive into specifics around different PostgreSQL parameters like shared_buffers, work_mem, maintenance_work_mem and how to set them depending on your workload. The presentation will also cover some of the lesser kn...

    @ Seattle 2024

    Nov 6 2024

    Essentials

    The first portion of the session will cover the critical reason why PostgreSQL generates these full page writes (FPW) and how to monitor the rate of generation. Next we will demonstrate the negative effect of full page writes on performance, scale, backups and replication. Then we will cover various techniques to decrease the amount of full page writes and improve your databases performance/sca...

    @ Silicon Valley 2023

    Apr 21 2023

    Ops

    Amazon Aurora with PostgreSQL compatibility is a relational database service that combines the speed and availability of high-end commercial databases with the simplicity and cost-effectiveness of open-source databases. In this session, we review the functionality in order to understand the architectural differences that contribute to improved scalability, availability, and durability. You'll a...

    @ Postgres Conference 2020
    AWS Day

    This talk will first introduce the different ways PostgreSQL can use memory, from the operating system, to cluster wide and then into per session and per operation. From there we will dive into specifics around different PostgreSQL parameters like shared_buffers, work_mem, maintenance_work_mem and how to set them depending on your workload. The presentation will also cover some of the lesser kn...

    @ Postgres Conference 2020
    Ops and Administration

    In this session we will dive deep into HOT (Heap Only Tuple) update optimization. Utilizing this optimization can result in improved writes rates, less index bloat and reduced vacuum effort but to enable PostgreSQL to use this optimization may require changing your application design and database settings. We will examine how the number of indexes, frequency of updates, fillfactor and vacuum se...

    @ Postgres Conference

    Mar 21 2019

    Ops and Administration

    In this session we will dive deep into HOT (Heap Only Tuple) update optimization. Utilizing this optimization can result in improved writes rates, less index bloat and reduced vacuum effort but to enable PostgreSQL to use this optimization may require changing your application design and database settings. We will examine how the number of indexes, frequency of updates, fillfactor and vacuum se...

    @ Silicon Valley

    Oct 16 2018

    Ops

    We will do a deep dive into the exciting new features we recently released, including 9.6 support, new extensions, snapshot sharing, enhancements to encryption, vacuum and replication. We will also explore lessons we have learned managing a large fleet of PostgreSQL instances, including important tunables and possible gotchas around pg_upgrade. During the session we also cover our newly announc...

    @ PGConf Local: Austin [PgConf.US]
    Cloud & Data

    In this session we will begin with a quick overview of the Amazon RDS service and how it achieves durability and high availability. Then we will do a deep dive into the exciting new features we recently released, including 9.6, snapshot sharing, enhancements to encryption, vacuum, and replication. We will also explore lessons we have learned managing a large fleet of PostgreSQL instances, inclu...

    @ PGConf US 2017 [PgConf.US]

    Mar 30 2017

    Operations

    This session will provide a brief overview of the RDS service, how it achieves durability & high availability and then do a deep dive into the exciting new features that we have released. We will also explore what we have learned by managing a large fleet of PostgreSQL instances including possible gotchas around pg_upgrade, advice on replication tunables, vacuum settings and shared_buffers incl...

    @ PGConf US 2016 [PgConf.US]
    Operations

    This session will provide a brief overview of the RDS service and then do a deep dive into the new features that we have released in the last few months including Read Replicas and supporting trigger based replications solutions . During the session we will also discuss the lessons learned n running a large fleet of PostgreSQL instances including specific recommendations.

    @ PGConf US 2015 [PgConf.US]
    Case-Study

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

    @ PostgresConf US 2018
    Postgres Internals