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.