Five methods for retrieving the most recent time-series data (for many items) in PostgreSQL

Time-series data is the backbone of many applications, tracking measurements from devices, financial transactions, and users at high frequencies. In nearly every application there is a need to frequently retrieve the most recent data point for each tracked item. As data grows, however, querying this information efficiently can become a bottleneck, even with properly tuned and indexed tables.

In this talk, I'll discuss the reason querying "last point" data in PostgreSQL can be problematic and demonstrate five approaches to keep your queries responsive. The size and scope of your data, as well as the development expertise on your team, will influence which approach is right for your situation. You'll leave the talk ready to evaluate your schema, indexes, and queries to keep your application running at peak performance.

Ryan Booz

Developer Advocate at Redgate

State College, Pennsylvania, United States


Please note that Sessionize is not responsible for the accuracy or validity of the data provided by speakers. If you suspect this profile to be fake or spam, please let us know.

Jump to top