No upcoming presentations...

    Always-On with Postgres BDR (Deploying with Multi-Master)

    The next generation of high availability.

    This course will present the Postgres-BDR Always-On architecture. It will do an in depth review of logical replication and high availability concepts.

    How to achieve maximum availability through a Postgres Multi-Master architecture will presented. Specific topics that will be covered:

    1) How to achieve zero down time upgrades. 2) How to quickly (under a second) failover. 3) How to failo...

    @ Postgres Conference 2020
    Ops and Administration

    MVCC and Tuple Freezing through Pictures.

    If you have an update or insert intensive application, please join us.

    Teams that deploy an insert or update intensive application with Postgres need to understand the topic of tuple freezing. In proper planning this important aspect of the Postgres MVCC architecture, can result in prolonged performance spike or an outage. Unfortunately, may people struggle with the concept of tuple freezing. Hence, DBAs and Developers become confused about how to design applica...

    @ Postgres Conference 2020
    Ops and Administration

    Proper Vacuum operations is an important function of any Postgres deployment. Vacuum is at the core of many Postgres operational items. Having a Postgres deployment properly tuned for vacuum is critical for all successful Postgres production instances.

    Unfortunately, may people struggle with the concepts behind vacuum and auto-vacuum. Hence, DBAs and Developers become extremely confused abou...

    @ Silicon Valley 2019

    Sep 20 2019

    Ops and Administration

    Logical Replication and pgLogical

    use cases from Near real time upgrades to Change Data Capture

    2ndQuadrant the contributors of logical encoding and logical replication to Postgres, has developed an open source extension called pglogical. This talk will cover the evolution of logical replication through out the history of Postgres and it will also cover the primary use cases of logical replication such as near real time upgrades and change data capture. It will then dive into specific f...

    @ Postgres Conference

    Mar 21 2019

    Use Cases

    This is a keynote presentation as part of 2ndQuadrant's sponsorship. This presentation will cover the new and exciting features in PG11. Specific topics will be stored procedures, new Partitioning enhancements and JIT compilation. There will also be a quick look at some of the smaller features.

    @ Silicon Valley

    Oct 15 2018

    Data

    Postgres -- Past, Present and Future

    What challenges most Postgres face in the next 5 years.

    This talk will give a short history of Postgres, speaking about its origins and it's original goals. It will then discuss the reasons for the rapid growth in adoption and development it has seen over the years. Finally, it will then discuss the opportunities and challenges that Postgres faces in the next 3-5 years. Sources and illustrations from this talk, will be based on interviews from activ...

    @ PostgresConf US 2018
    Use Cases

    Internet of Things with PostgreSQL - Performance & Security

    An in depth look at Postgres together IOT

    Gartner predicts that there will be over 21 billion connected devices in the world by 2020 [https://www.gartner.com/doc/3299317]. More than anything else, this number drives all 3 Vs of Big Data: Velocity, Volume, Variety. The Internet of Things (IoT) causes some challenges for any database system: security, resource consumption, ingestion rate, replication as well as coping with various acces...

    @ PostgresConf US 2018
    Cloud