Use TimescaleWrite data

About writing data

Timescale supports writing data in the same way as PostgreSQL, using INSERT, UPDATE, INSERT ... ON CONFLICT, and DELETE.

Note

Timescale Cloud is optimized for running real-time analytics workloads on time-series data. For this reason, hypertables are optimized for inserts to the most recent time intervals. Inserting data with recent time values gives excellent performance. However, if you need to make frequent updates to older time intervals, you might see lower write throughput.

Keywords

ingest

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

PreviousWrite dataNextInsert data

Related Content

Write data
Learn to write data in your Timescale Cloud service with SQL
Insert data
Insert single and multiple rows and return data in your Timescale Cloud service with SQL
Delete data
Delete data with DELETE or by dropping chunks from a hypertable in your Timescale Cloud service using SQL
Update data
Update single and multiple rows in a hypertable in your Timescale Cloud service with SQL
Upsert data
Insert a new row or update an existing row in a hypertable in your Timescale Cloud service using UPSERT
Ingest data using Kafka
Ingest data into your Timescale Cloud service using the PostgreSQL Kafka connector