Many real-world processes produce information as a steady stream relatively than as remoted information. Sensor readings, monetary markets, and utility telemetry all generate information this manner. This sort of time-series information has a particular form. It’s written way more usually than it’s up to date, it accumulates constantly, and it’s often queried throughout ranges of time. Time-series databases are constructed particularly for this type of workload.
TimescaleDB is an open supply database from Tiger Information that provides time-series capabilities to PostgreSQL. It’s carried out as a Postgres extension, so it introduces new performance whereas preserving commonplace Postgres habits and SQL. This lets a single Postgres-based system deal with each transactional and analytical workloads with out splitting information throughout a number of instruments.
Brandon Purcell is the Director of Product Administration at Tiger Information. On this episode, Brandon joins Kevin Ball to debate why time-series information breaks typical databases, how hypertables and Hypercore scale Postgres, zero-copy database forking for agent-based workflows, and way more.
Full Disclosure: This episode is sponsored by Tiger Information
Sponsorship inquiries:
[email protected]
