Managing Postgres at scale: Challenges, Tools & Techniques

Managing databases at scale can be hard! Databases keep getting bigger, and organisations are managing more and more databases. To make things even more challenging, you may be one of the many people who are expected to implement and look after database systems who isn’t actually a database administrator. Maybe your training and expertise lies in other areas such as sysadmin, devops or application development.

In this session, we’ll think about some of the difficulties you might encounter when managing databases at scale, whether that means looking after multi-terabyte databases or being responsible for hundreds or even thousands of databases. More importantly, we’ll look at the skills, tools and techniques that you can rely on to manage them successfully. This will include topics such as:

• architecture
• automation
• disaster recovery, high availability & backups
• sizing, memory and storage
• partitioning and sharding options
• monitoring and alerting