David Kohn
Software Engineer at Timescale
Upcoming presentations
No upcoming presentations...
Past presentations
Storage systems like databases and file systems have long used compression to reduce their storage footprint. Yet the most effective compression were traditionally limited to column stores, where increased data-type locality provides greater options for advanced techniques. It has often been assumed that fundamental differences between column-store and row-store architectures lead to these op...
Oct 24 2019
Advanced compression in TimescaleDB with hybrid row/columnar storage
Introducing state-of-the-art compression techniques through hybrid row/columnar storage representations
Storage systems like databases and file systems have long used compression to reduce their storage footprint. Yet the most effective compression were traditionally limited to column stores, where increased data-type locality provides greater options for advanced techniques. It has often been assumed that fundamental differences between column-store and row-store architectures lead to these op...
Sep 19 2019
Creating Continuously Up to Date Materialized Aggregates
Using Postgres Features to Speed Your Queries
Time-series workloads (i.e. data from sensors, IoT devices, finance, or even satellites) are generally insert-mostly, and data typically arrives in time order (at regular or irregular intervals). Given the high velocity and continuous workload of writing time-series, insert performance is paramount. But what is the use of inserting a significant amount of data if you can't analyze, visualize, a...
Sep 19 2019
The European Space Agency Solar Orbiter mission's objective is to perform close-up, high-resolution studies of our Sun and inner heliosphere, through a combination of in-situ and remote-sensing instruments. The products obtained will be stored within the Solar Orbiter Archive (SOAR). All the in-situ measurements have the form of time series products which will hold hundreds of millions values. ...
