No upcoming presentations...

    Always Online or Bust

    Performing Zero Downtime Postgres Upgrades

    Postgres major version upgrades are a lot of work! Before you start reaching for that handy pg_upgrade utility and accepting the inevitable downtime as part of the equation, let us describe a Better Way™. You didn’t set up an entire High Availability cluster just to shut it down for an upgrade, did you? Of course not!

    Postgres 10 introduced native logical replication, and in doing so, secret...

    @ Postgres Conference 2025

    Mar 20 2025

    Ops

    What's our Vector, Victor?

    Taking the pain out of AI with pg_vectorize

    AI is a hot topic right now, and for good reason! Natural Language Search and Retrieval Augmented Generation (RAG) are two great ways to leverage data stored in Postgres in an immediately useful way. Why use Full Text Search when we can search for intent and related topics?

    Actually doing it on the other hand is a huge pain. We need to choose an embedding model to vectorize the data, t...

    @ Seattle 2024

    Nov 6 2024

    Dev

    Kubernetes Killed the High Availability Star

    How to stop worrying and embrace Postgres in the cloud

    Doing High Availability with Postgres is hard. So hard that even the experts get it wrong due to unforeseen edge cases. Quorum, CAP and PACELC theory, fencing, STONITH, network partitions and split brains, RPO, RTO, SLA, sync and async replication, node count and architecture, proxies, connection pools, load balancers... And then there's the tools! EFM, repmgr, Patroni, Stolon, pg_auto_fail...

    @ Seattle 2024

    Nov 7 2024

    Ops

    Upgrade Techniques Through the Ages

    From Dump / Restore to Logical and Beyond

    Back in my day we suffered the crushing hardship of dump and restore, hours of downtime both ways, and we liked it! Wait... no we didn't! Thankfully things have advanced since then, and we'd like to talk about it. Along the way, we'll cross every milestone up to fully online major version upgrades.

    There are even rumors of mixed-version operational clusters for truly zero-downtime u...

    @ Postgres Conference 2020
    Ops and Administration