David Kohn

Software Engineer at Timescale

About

David Kohn has presented the following presentations

Advanced compression in TimescaleDB with hybrid row/columnar storage at Mini NYC 2019

presented by David Kohn
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...
more
Thu 24 2019
Advanced compression in TimescaleDB with hybrid row/columnar storage at Silicon Valley 2019
Introducing state-of-the-art compression techniques through hybrid row/columnar storage representations
presented by David Kohn
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...
more
Thu 19 2019 Ops and Administration
Creating Continuously Up to Date Materialized Aggregates at Silicon Valley 2019
Using Postgres Features to Speed Your Queries
presented by David Kohn
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...
more
Thu 19 2019 Data
Time-series for the European Space Agency Solar Orbiter Archive with TimescaleDB at PostgresConf US 2018

presented by Hector Perez and David Kohn
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. ...
more
Use Cases