Skip to content
TimescaleDB - Timeseries database for PostgreSQL Docs
  • Timescale.com
  • Try for free
Get started
Create your first Timescale service
Try the key Timescale features
Start coding with Timescale
About Timescale products
Timescale architecture for real-time analytics
Pricing plans and account management
Changelog
Use Timescale
Hypertables
About hypertables
Create hypertables
Change hypertable chunk intervals
Alter hypertables
Create unique indexes on hypertables
Improve query performance
Drop hypertables
Troubleshoot hypertables
Hypercore
Continuous aggregates
Tutorials
Integrations
API Reference
Migrate and sync data to Timescale Cloud
AI and Vector: pgai on Timescale
Other deployment options
Find a docs page
Use Timescale

Hypertables

Hypertables are PostgreSQL tables designed to simplify and accelerate data analysis. Anything you can do with regular PostgreSQL tables, you can do with hypertables - but much faster and more conveniently. In this section, you:

  • Learn about hypertables
  • Create a hypertable
  • Change hypertable chunk intervals
  • Alter a hypertable
  • Create unique indexes on hypertables
  • Drop a hypertable
  • Improve query performance
  • Troubleshoot hypertable issues

Keywords

hypertables

Found an issue on this page?Report an issue or Edit this page in GitHub.

PreviousUse TimescaleNextAbout hypertables

Related Content

Compression
With data compression, you can achieve a significant improvement in the performance of your analytical queries. Learn how to enable and benefit from data compression in Timescale Cloud
Limitations
Timescale Cloud features come with a few limitations that we are constantly working to remove. See the current and regularly updated list of limitations
Drop a hypertable
Delete a hypertable from your Timescale Cloud service using a standard PostgreSQL DROP TABLE command
Alter a hypertable
Alter a Timescale Cloud hypertable to better suit your needs by using the PostgreSQL ALTER TABLE command. See examples for adding a column and renaming a hypertable
Delete data
Delete data with DELETE or by dropping chunks from a hypertable in your Timescale Cloud service using SQL
Insert data
Insert single and multiple rows and return data in your Timescale Cloud service with SQL