600k queries per second in PostgreSQL - we do it in TomTom
10+ years of experience with Java and RMDS systems. Not really a DBA, but a software engineer with responsibility of delivering high quality software that solves problems.
Co-speaker Rafał Hawrylak. In this talk, we will present how we, at TomTom, created a large scale application based on PostgreSQL. What changes when traffic grows from MBs to GBs per day, environment from 1 server to several powerful machines and volume of data to 30TB? We want to share how PostGIS enabled us to create a geospatial platform. How we achieved high read scalability and allow database input of 200GB a day. Is replication solving all the problems? Tracking system metrics is important and our production environment contains 200+ servers in the in-house data-center and from Amazon Web Services. We will show how we monitor and improve application performance. Some of the strategies are generally applicable and some are specific to our deployment. Regardless, we think that information will be useful to anyone planning or currently working with large applications based on PostgreSQL.
- 50 min
- PGConf US 2017
- Use Cases