Upcoming presentations
No upcoming presentations...
Past presentations
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...
PostgreSQL as a Big Data Platform
How to Use Postgres like People Use Hadoop
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 ...
Data Recovery in PostgreSQL on a damaged filesystem
A Case Study
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...
PostgreSQL at 20TB and Beyond
Analytics at a Massive Scale
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...
Advanced Data Modelling techniques
Up your Data Modelling Game
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...