Christopher Travers

Database Administrator at Adjust GmbH

About

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.

    Christopher Travers When it All Goes Wrong - Incident Response in Large Postgres Databases

    presented by Christopher Travers


    video

    When things go wrong with large, heavily loaded systems, it can take a significant amount of time to recover. For this reason, the same response patterns with other critical systems (nuclear power plants, jumbo jets) apply to disaster management here as well.

    This talk is a story of how we at Adjust managed one such disaster and what you can learn from it. The talk will also include what w...

    more

    Tue 15 2021 Ops
    Christopher Travers PostgreSQL as a Big Data Platform
    How to Use Postgres like People Use Hadoop

    presented by Christopher Travers

    In this talk for all audiences, I provide a whirlwind survey of three of our big data environments at Adjust all built on PostgreSQL. These environments are all very different in structure and operation.

    One takeaway from this is that it is quite possible to apply NoSQL-like strategies to horizontally scaling various kinds of PostgreSQL analytical environments, but since every large system ...

    more

    Thu 19 2019 Data
    Christopher Travers Data Recovery in PostgreSQL on a damaged filesystem
    A Case Study

    presented by Christopher Travers

    After a power outage took all our db servers offline suddenly, two of them failed to come back. We decided to do data recovery on these systems in order to reduce the amount of data loss. This talk will focus on both the technical and non-technical aspects of data recovery used, and what anyone should be aware of when trying to recover data from PostgreSQL.

    We will discuss the causes of th...

    more

    Mon 15 2018 Ops
    Christopher Travers PostgreSQL at 20TB and Beyond
    Analytics at a Massive Scale

    presented by Christopher Travers

    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 mo...

    more

    Thu 19 2018 Use Cases
    Christopher Travers Advanced Data Modelling techniques
    Up your Data Modelling Game

    presented by Christopher Travers

    This training focuses on leveraging PostgreSQL as a data modelling platform, rather than simply as a relational database. As a data modelling platform we have many techniques which can be used to more efficiently manage the data we have, sometimes adding features to applications which would be impossible to add through other means.

    This training focuses on advanced data modelling techniques...

    more

    Postgres Internals