TimescaleDB Data Retention

Introduction If you’re using TimescaleDB to store time-series data, you know how quickly this type of data can accumulate in your database. New data is constantly being added, and older data becomes less relevant as time goes on. It often makes sense to free up disk space and delete older records; however, using a typical … Continued

TimescaleDB CREATE TRIGGER

Introduction If you’re using TimescaleDB to store and manage data that changes with time, you may wonder if you can implement triggers in this time-series database. The answer is “yes”: TimescaleDB supports the table objects that are supported by PostgreSQL, which includes indexes, data types and triggers. You can use the PostgreSQL CREATE TRIGGER statement … Continued

Keep in the know!

Subscribe to our emails and we’ll let you know what’s going on at ObjectRocket. We hate spam and make it easy to unsubscribe.