Use TimescaleWriting 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!
PreviousWrite dataNextInsert data

Related Content

Writing 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
PostgreSQL Kafka connector
Ingest data into Timescale using the PostgreSQL Kafka connector