Building a Scalable Time Series Database on PostgreSQL

Wednesday 12:20PM-1:10PM

@ Swift Suite 2

Open Source Databases

50 minutes conference

Intermediate

Tracks:
Developer

When storing time-series data, many developers start with some well-trusted system like Postgres, but as their data hits a certain scale, give up its query power and ecosystem by migrating to a NoSQL or other "modern" time-series architecture.

In this talk, I describe why this trade-off is unnecessary, and how we've built TimescaleDB, an efficient, scalable time-series database engineered up from Postgres. The nature of time-series workloads--appending data about recent events--presents different demands than transactional (OLTP) workloads. We've architected our time-series database to take advantage of and embrace these differences.

TimescaleDB improves insert rates by 15X over Postgres, even on a single node. By right-sizing chunks, it avoids the "performance cliff" Postgres experiences once reaching table sizes of 50+ million of rows, while offering compelling complex query performance improvements. TimescaleDB is packaged as a Postgres extension, released under the Apache


Speakers

Erik Nordström

Erik Nordström (Timescale)

Senior Software Engineer

Biography:

Erik is a senior software engineer at Timescale, focusing on both the core database and infrastructure services. Before joining Timescale, he worked at Spotify on their backend service infrastructure. Erik earned his MSc and PhD from Uppsala in Sweden, then worked as a postdoc and research scientist at Princeton. In his (post)doctoral work, he largely focused on networking and distributed systems, including a new end-host network stack for service-centric networking.


Slides



  Download Slides  

Percona Live

Stay Connected on:

Percona Live Conferences

The Percona Live Open Source Database Conferences are the premier event for the diverse and active open source database community, as well as businesses that develop and use open source database software.
 

Contact Us

For general information about the event/expo/conference, including registration, please contact us at:

  • info(@) percona.com
  • +1-888-401-3401
  • +1-919-948-2863
  • 8081 Arco Corporate Drive - Suite 330 - Raleigh, NC 27617, USA