timescaledb-benchmark-delete

command
v0.0.0-...-8b6c47a Latest Latest
Warning

This package is not in the latest version of its module.

Go to latest
Published: Mar 12, 2018 License: Apache-2.0 Imports: 5 Imported by: 0

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

Jump to

Keyboard shortcuts

? : This menu
/ : Search site
f or F : Jump to
y or Y : Canonical URL