Company
Date Published
Author
Sven Klemm
Word count
1081
Language
English
Hacker News points
None

Summary

With the release of TimescaleDB 1.2 and its subsequent updates, the database has gained support for Ordered Append, a feature that optimizes performance by leveraging range partitioning and eliminating sorting steps in queries ordered by time, particularly those with LIMIT clauses. This optimization results in significant performance improvements of up to 100x depending on the query, making it beneficial for time-series workloads. The addition of space-partition awareness and removal of LIMIT clause restrictions further expands its applicability. The feature is especially useful for queries that require fetching the last reading from a sensor or similar use cases. To utilize Ordered Append, users must have TimescaleDB 1.2 or higher installed, with the latest version being recommended for optimal benefits.