Simon Riggs

New in PostgresSQL 15, the MERGE command is part of the SQL Standard and allows INSERTs, UPDATEs and DELETEs to be applied to a target table. This talk provides a basic overview of MERGE, with examples, then covers all the more advanced topics including optimization and triggers.

Database Lock Waits, Deadlocks and Serializable ERRORs lurk in wait for the unwary application developer. This talk explains what they are, how to spot they are causing problems and how to reduce them.

Introduction to Postgres-BDR Postgres-BDR Architecture High Availability, Disaster Recovery, Rolling Upgrades, Latency and Geographical Distribution with Postgres-BDR Common use cases for Postgres-BDR Making applications compliant with Postgres-BDR

Update your PostgreSQL DBA knowledge to the latest version with this fast-paced training, showing how some important topics have changed over the last few releases.

Keynote for PgConf.US, as a result of being a Sponsor: Simon describes the ways in which PostgreSQL is capable of many use cases, catering for many different kinds of data model and data handling.

Covers the essential tools and utilities required by Financial Industry professionals. * High Availability (with and without BDR) * Online upgrades * Auditing & Certification * PCI-Compliant Security * Client tools and Monitoring * Performance tooling Covers both core PostgreSQL and 2ndQuadrant products and services.

PostgreSQL Partitioning has been through many different versions. Declarative partitioning in PG10 has many enhancements and some very subtle performance effects and changes.

PostgreSQL contains everything you need for managing application data. Review all of the different aspects of PostgreSQL data management, including GIS, full text, graph, document storage, time series and of course relational.