TimescaleDB (An open-source time-series SQL database optimized for fast ingest and complex queries)

• https://github.com/timescale

• https://github.com/timescale/timescaledb

• https://github.com/timescale/timescaledb/commits.atom

• https://blog.timescale.com/blog/top-5-postgresql-extensions/

• Articles
  • 2023
    • 2023-04
• PostgreSQL TimescaleDB installation
  • Install TimescaleDB on GNU/Linux Debian
    • Step 1 At the command prompt, as root, add the PostgreSQL third party repository to get the latest PostgreSQL packages
    • step 2 Run the PostgreSQL repository setup script
    • Step 3 Add the TimescaleDB third party repository
    • Step 4 Install TimescaleDB GPG key
    • Step 5 Update your local repository list
    • Step 6 Install TimescaleDB
    • Step 7 Configure your database by running the timescaledb-tune script
  • Set up the TimescaleDB extension
    • Install psql on Linux
  • Setting up the TimescaleDB extension on Debian-based systems
    • 1. Restart PostgreSQL and create the TimescaleDB extension:
    • 2. On your local system, at the command prompt, open the psql command-line utility as the postgres superuser
    • 3. Set the password for the postgres user
    • 4. Exit from PostgreSQL
    • 5. Use psql client to connect to PostgreSQL
    • 6. At the psql prompt, create an empty database. Our database is called tsdb
    • 7. Connect to the database you created
    • 8. Add the TimescaleDB extension
    • 9. On constate la création de nombreuses tables timescaleDB
  • Disabling telemetry
    • 1. Open your PostgreSQL configuration file, and locate the timescaledb.telemetry_level parameter
    • 2. Add the parameter setting to off
    • 3. Reload the configuration file
• Used by
  • locust-ci
    • locust-ci Docker TimescaleDB installation