Schedule - PGConf.EU 2015

One National Health System - One Postgres Database (Architecture and Performance Review)

Date: 2015-10-28
Time: 17:20–18:10
Room: Ballroom A+B
Level: Intermediate

In this presentation, we will present the overall architecture of the Macedonian National Health System http://mojtermin.mk which consissts of tens of different applications and services, which have at it’s core one main Postgres database cluster. We will present how we maintain the high uptime and availability of a system under active development with database size of 100s of GB and over 10M transactions per day on a single master server. The presentation will be done from the development and the administration perspective, focusing on the optimization of the system load and the overall architecture choices that had to be made to achieve the desired performance. We will present experiences on how we’re managing: database change management and migration, auditing, security, staging and uat environments, performance monitoring, system alerts and replication and also review how we handled several specific high alert situations.

Speaker