PostgreSQL at 20TB and Beyond
Chris Travers works in Berlin as a database administrator, in a distributed PostgreSQL environment involving hundreds of TB of data in PostgreSQL. He has experience working with PostgreSQL in many areas from scientific computing in the life sciences, to ERP, from high-velocity ad-tech analytics to geo-spacial databases. He is the author of a number of extensions on pgxn.
His current experience involves mobile advertisement analytics over 400TB data sets and more short-terms log management environments handling PBs of data in PostgreSQL.
In the last six months I have been working as a database administrator in a 400TB analytics environment built entirely on stock PostgreSQL with local enhancements. Come and listen to the problems we have encountered, problems we are still solving, and solutions we use to deliver analytics at this scale.
Topics will include how and why we use C-language extensions, scaling challenges, and moving data around the datacenter.
- 2018 April 19 09:50 EDT
- 50 min
- PostgresConf US 2018
- Use Cases