Home / Companies / Tiger Data / Blog / Post Details
Content Deep Dive

Database Indexes in PostgreSQL and Timescale Cloud: Your Questions, Answered

Blog post from Tiger Data

Post Details
Company
Date Published
Author
Evan Davis
Word Count
1,434
Company Posts That Month
6
Language
English
Hacker News Points
-
Post removed?
No
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.

Trends Found in this Post

No tracked trend matches for this post yet.

Use This Data

Use this post, company, and trend context to find content marketing opportunities, perform competitive analysis, or address product feature gaps via the Plushcap MCP server or the Plushcap API.