Andrew Dunstan
PostgreSQL Architect at 2ndQuadrant
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.
Upcoming presentations
No upcoming presentations...
Past presentations
- prerequisites for running Barman
- t...
- 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...
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...
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
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...
Sep 20 2019
This talk provides an introduction to setting up PostgreSQL and pgbouncer to use SSL securely and effectively. It will cover
Sep 20 2019
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 ...
Mar 21 2019
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.
Mar 21 2019
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...
Apr 20 2018