Company
Date Published
Author
Evan Davis
Word count
1434
Language
English
Hacker News points
None

Summary

Timescale Cloud provides impressive time-series optimizations on top of PostgreSQL, offering performance at scale, cost-efficiency, and all the time-series features needed without a separate learning curve. Database indexes in Timescale Cloud work similarly to those in regular PostgreSQL, with some additional considerations for hypertable-specific indexing. When converting a PostgreSQL table to a hypertable, existing indexes are preserved and can be used as usual, while new indexes can also be created directly on the hypertable using the standard CREATE INDEX method. The use of indexes with hypertables is fully supported, but there is a limitation on concurrent index creation. Timescale Cloud manages chunks as separate PostgreSQL tables, each with its own set of indexes, and query planning takes into account internal partitioning into chunks automatically.