No upcoming presentations...

    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

    Backup PostgreSQL with Barman

    Planning for when disaster happens

    A backup solution is an essential part of almost any Disaster Recovery Plan. Barman is a mature, well maintained, open source, continuous backup solution for PostgreSQL. This talk will explain the various options for running Barman, and how using it you can have robust protection against data loss from system failure or corruption. Topics will include

    • prerequisites for running Barman
    • t...

    @ 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

    This talk provides an introduction to setting up PostgreSQL and pgbouncer to use SSL securely and effectively. It will cover

    • what SSL provides - encryption and authentication
    • levels of SSL verification
    • client certificates and server certificates
    • use of self-signed certificates for testing
    • creation and use of Certificate Authorities
    • use of intermediate Certificate authorit...

    @ Silicon Valley 2019

    Sep 20 2019

    Ops and Administration

    The PostgreSQL Ecology

    Everything else you need for a successful deployment

    PostgreSQL is not deployed in a vacuum, it relies on many other elements. This talk focuses on all the things that aren't PostgreSQL that you need to make your use of it easy and successful. We'll talk about tools for administration, for monitoring, for backups, for high availability, for debugging, for disaster recovery. We'll also talk about the elements of a management plan for a successful ...

    @ Postgres Conference

    Mar 21 2019

    Ops and Administration

    Stored procedures have arrived with PostgreSQL version 11. Come see what has been implemented, and how procedures differ from functions. We will discuss some use cases for procedures such as migrating from other database management systems and manipulating data.

    @ Postgres Conference

    Mar 21 2019

    Development

    Contributing to PostgreSQL

    How to do the best for both the community and yourself or your company.

    This talk will focus on the various ways that individuals can contribute to the survival and development of PostgreSQL. This can include provision of time, resources and money in a variety of ways. Sometimes the community can be a little difficult for newcomers to get to grips with. We will discuss how people in different roles, including developers, translators, documenters, and testers c...

    @ PostgresConf US 2018

    Apr 20 2018

    Development