Documentation ¶
Overview ¶
timescaledb-benchmark-delete measures the time (in milliseconds) to delete data from two systems: (1) TimescaleDB (by using the default --use-drop-chunks flag) (2) PostgreSQL (by setting the --use-drop-chunks flag to 'false')
Typical use for testing TimescaleDB timescaledb-benchmark-delete --amount=6h --limit=5
This will drop five 6-hour intervals from default database & table starting at the default start date, outputting the SQL command used and the time in milliseconds it took. By default, this uses TimescaleDB's `drop_chunks()` function.
---------- Typical use for testing PostgreSQL timescaledb-benchmark-delete --amount=6h --limit=5 --use-drop-chunks=false
This will drop five 6-hour intervals from default database & table starting at the default start date, outputting the SQL command used and the time in milliseconds it took. This will use a normal SQL `DELETE` command