Schedule - PGConf.EU 2016

PostgreSQL in TomTom - lessons learned

Date: 2016-11-02
Time: 17:20–18:10
Room: Omega
Level: Intermediate

What can happen when you use PostgreSQL in production environment? What changes when your traffic grows from MB to GB per day, environment from 1 server to several powerful machines and volume of data to 30TB.

In this talk, I will present how we, at TomTom, handle a production environment with 40+ servers in an in-house datacenter and in the cloud. Is replication solving all the problems? I will show how we monitor and improve performance. How to plan migrations and house-keeping, and what's important, what can go wrong when you don't expect it.

Most of our strategies are generally applicable. However, some are specific to our deployment. Regardless, I hope that information will be useful to anyone planning or currently working with large database applications in PostgreSQL.

Speaker