TigerData / TimescaleDB

wikipedia:TimescaleDB (Nov 2018) is an open-source time-series SQL database optimized for fast ingest and complex queries. Packaged as a PostgreSQL extension.

• https://www.timescale.com/
• Michael J. Freedman
• https://trends.google.com/trends/explore?date=all&q=TimescaleDB,InfluxDB

Installation

• TimescaleDB installation
• brew tap timescale/tap
• brew install timescaledb
• Status: systemctl status postgresql@14-main
• Configuration: postgresql.conf

Binaries

• timescaledb-tune
• timescaledb_move.sh
• timescaledb-parallel-copy

Errors

ERROR: could not access file "$libdir/timescaledb-2.10.3": No such file or directory
ERROR #58P01 could not access file "$libdir/timescaledb-2.10.3": No such file or directory. Retrying...

Related

• InfluxDB (2013)
• Data partitioning
• Hypertable: create_hypertable
• CREATE EXTENSION timescaledb;
• Timescale Cloud
• TimescaleDB versions
• Port: 5432, 7432

• SELECT * FROM timescaledb information.hypertables WHERE hypertable name = 'data'

See also

• TigerData / TimescaleDB, Installation, tsdb, Timescale Cloud: brew install timescaledb, timescaledb-tune, timescaledb_move.sh, create_hypertable, versions, Timescale Vector, timescaledb_toolkit
• TSDB: Prometheus, InfluxDB, RRDtool, Graphite, Telegraf, OpenTSDB, TimescaleDB, tsdbadmin