Ingesting 1M Inserts per Minute to Help Save Devs’ Resources
In this edition of "Community Member Spotlight", Adam McCrea, founder and developer of Judoscale, explains how he uses Timescale to help developers save on costs by handling a million inserts per minute with frequent, automatic data retention policies and data rollups. Judoscale is a tool that helps engineering teams manage their server resources by automatically scaling resources based on traffic metrics and other factors. The majority of their customers are still on the Heroku hosting platform, where they access Judoscale through its dashboard to see real-time metrics on their server resources. Before using Timescale, Judoscale had a homegrown time-series solution with Redis that was not scaling well as their business grew. They found Timescale built on top of PostgreSQL and decided to move everything to it for better stability, reliability, and faster development. The automatic data retention policy runs every 10 minutes, and they only retain the most recent hour of data, dropping everything else. For the data rollups, they retain two days of aggregations, running that retention every day. They have also expanded beyond Heroku to provide the same autoscaling experience to customers hosting their applications on AWS.
Company
Timescale
Date published
May 8, 2024
Author(s)
Adam McCrea
Word count
2032
Hacker News points
None found.
Language
English