Schedule - PGConf.EU 2014
Scaling a SaaS backend with PostgreSQL
Date: 2014-10-24
Time: 09:30–10:20
Room: Medici III
Level: Advanced
At Adspert we store and analyze more than 3 TB of data in PostgreSQL databases. By separating each customers data into its own database we can scale very well horizontally. I will talk about the benefits and challenges of that approach as well as how we came to adopt it and why we chose it above alternatives.
Additionally, we rely a lot on SQL for gaining deep insight into the data and we use SCHEMAs a lot for versioning our database code. I will expand on how we manage this and how we integrate schema changes into the software development process.
