How TimescaleDB Expands the PostgreSQL IIoT Performance Envelope
Earlier in the week I looked at how upgrading hardware can expand the PostgreSQL performance envelope. Now I’m going to show another solution: TimescaleDB. TimescaleDB is an open-source PostgreSQL extension that adds time-series capabilities to PostgreSQL. It was first released in 2017 by Tiger Data (originally Timescale) and is available for free as a self-hosted extension or as a managed service (Tiger Cloud). Under the hood, TimescaleDB automatically partitions tables into time-based chunks (called hypertables), adds native compression with hypercore, continuous aggregates for pre-computed […]