timescaledb-extras

This repository includes helper functions and procedures for TimescaleDB, particularly as a staging ground for features not ready or appropriate for the core database, including those written in PL/pgSQL.

The current list of "extras" include:

Diagnostic checks

diagnostic.sql : Checks for common misconfigurations and issues that can affect performance and reliability of TimescaleDB installations.

Useful views

In the views/ directory, there is a number of views that can be useful. The views are typically added as separate files to allow you to just include the views that you're interested in.

chunks.sql : Defines views to get information about the time ranges and tablespace for chunks.

Useful utilities

compression.sql : Define utilities for working with compressed tables.

migrate.sql (documentation) : Incrementally copy existing time-series data from large tables into a new hypertable.

Documentation and Help

• Why use TimescaleDB
• Writing data
• Querying and data analytics
• Tutorials and sample data
• Community Slack Channel

Contributing

We welcome contributions to TimescaleDB Extras. The same Contributor's Agreement applies as in TimescaleDB; please sign the Contributor License Agreement (CLA) if you're a new contributor.