I'm a holistic system software engineer, PostgreSQL consultant and trainer, free software activist, and headbanger. I have been working with PostgreSQL since version 9.1. First, as part of my job related to other projects, and now with full dedication since I joined 2ndQuadrant in 2017. I have a background as teaching-assistant and researcher on self-managing distributed systems, and I have presented in different conferences. In open source, I have contributed to the Mozart-Oz programming language and Alfresco communities. In 2018 I have started the PostgreSQL User Group in Belgium.
Table partitioning has been supported in PostgreSQL since many years as a design pattern of table inheritance. Since PostgreSQL version 10, there is support for declarative table partitioning. The new features of declarative partitioning included in PostgreSQL 11 represent an important improvement in its ease of use, and the use cases that are now covered. In this talk, we will review with concrete examples why you would benefit from table partitioning, how to use declarative partitioning, and what are the implications of taking some decisions when designing the schema.
Having a replicated environment is very common nowadays. So common that PostgreSQL configuration settings for replication are active by default. But when it's so common, people starts to forget how it works and what to do when the system start presenting failures. In this talk we will review the main concepts behind physical streaming replication, how to monitor it, how some settings affect it, what to do in case of failure and some interesting tips and tricks. We will also explore the differences with logical replication, and what are the advantages, challenges and risks of multi-master architecture.