16min chapter

Software Engineering Radio - the podcast for professional software developers cover image

SE Radio 623: Michael J. Freedman on TimescaleDB

Software Engineering Radio - the podcast for professional software developers

CHAPTER

Optimizing Time Series Databases with TimescaleDB

This chapter delves into the unique features of TimescaleDB compared to other time series databases, emphasizing its focus on append heavy operations, long-term scans, and fast queries through materialization. It explores the advantages of building on top of Postgres for flexibility, rich query capabilities, and an established ecosystem. The discussion covers setting up TimescaleDB for time series projects, operational aspects like backups and upgrades, managing high availability replicas for failover, and the importance of proficient DBAs or managed services for large-scale databases.

00:00

Get the Snipd
podcast app

Unlock the knowledge in podcasts with the podcast player of the future.
App store bannerPlay store banner

AI-powered
podcast player

Listen to all your favourite podcasts with AI-powered features

Discover
highlights

Listen to the best highlights from the podcasts you love and dive into the full episode

Save any
moment

Hear something you like? Tap your headphones to save it with AI-generated key takeaways

Share
& Export

Send highlights to Twitter, WhatsApp or export them to Notion, Readwise & more

AI-powered
podcast player

Listen to all your favourite podcasts with AI-powered features

Discover
highlights

Listen to the best highlights from the podcasts you love and dive into the full episode