Andrew Dunstan

PostgreSQL Architect at 2ndQuadrant

About

Andrew has been contributing to PostgreSQL since 2002 and has been a committer since 2005. He has contributed in a many areas, including configuration and logging enhancements, dollar quoting, CSV import and export, improvements to plperl, the Windows port, rewriting the initdb and pg_ctl scripts in C, parallel pg_restore and more recently JSON features and fast column addition. He created and maintains the PostgreSQL Buildfarm.

Andrew Dunstan has presented the following presentations

    Tom Kincaid Andrew Dunstan MVCC and Tuple Freezing through Pictures. at Postgres Conference 2020
    If you have an update or insert intensive application, please join us.

    presented by Tom Kincaid and Andrew Dunstan

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

    more

    Ops and Administration
    Andrew Dunstan Backup PostgreSQL with Barman at Postgres Conference 2020
    Planning for when disaster happens

    presented by Andrew Dunstan

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

    Ops and Administration
    Tom Kincaid Andrew Dunstan Vacuuming through pictures at Silicon Valley 2019

    presented by Tom Kincaid and Andrew Dunstan

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

    more

    Fri 20 2019 Ops and Administration
    Andrew Dunstan Using SSL with PostgreSQL and pgbouncer at Silicon Valley 2019

    presented by Andrew Dunstan

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

    Fri 20 2019 Ops and Administration
    Andrew Dunstan The PostgreSQL Ecology at Postgres Conference
    Everything else you need for a successful deployment

    presented by Andrew Dunstan

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

    more

    Thu 21 2019 Ops and Administration
    Andrew Dunstan Stored Procedures at Postgres Conference

    presented by Andrew Dunstan

    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.

    Thu 21 2019 Development
    Andrew Dunstan Contributing to PostgreSQL at PostgresConf US 2018
    How to do the best for both the community and yourself or your company.

    presented by Andrew Dunstan

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

    more

    Fri 20 2018 Development