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

Because Timescale is a time-series database, 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
Write data to TimescaleDB
Insert data
Insert data into a hypertable
Delete data
How to delete data from Timescale
Update data
Update data in a hypertable
Upsert data
Upsert data to insert a new row or update an existing row
Ingest data using Kafka
Ingest data into a Timescale Cloud service using the PostgreSQL Kafka connector