23.3k stars · Apache-2.0 on the core, with some features under the Timescale License, which forbids offering it to others as a database service · 2.30.0 (2026-09-08), read from /releases/latest
A PostgreSQL extension for time-series data — automatic time chunking, compression of old chunks, and continuous aggregates.
▶Repo detailsthe review · specs · pros & cons · install
What it is
TimescaleDB is an extension for PostgreSQL built for data with a timestamp. It splits one big table into time-based pieces on its own, compresses the older pieces, and keeps rolling summaries up to date.
Why it matters
You have around three years of EURUSD data and one goal: find a pattern worth about 2% a month. Finding a pattern means asking the same question hundreds of times with different settings. If one pass takes a minute, you test ten ideas in an afternoon. If it takes a second, you test hundreds. That is the whole difference between searching and guessing. The rolling summaries also give you one-minute, five-minute and hourly bars kept current for you, instead of rebuilding them in Python on every run.
- It is still PostgreSQL. Same connection string, same SQL, same backups. Nothing else in ScalpingMate has to change.
- Compressing older pieces usually cuts stored size a great deal, which matters on a VPS disk you pay for.
- It is very active. Version 2.30.0 was published on 8 September 2026.
- There are two licences in one repository. The core is Apache-2.0. Some features sit under the Timescale License, which forbids offering it to others as a database service. Selling ScalpingMate is fine. Reselling the database is not.
- Installing it means matching your PostgreSQL version and restarting the server. Test it on a copy of your data first, never on the live one.
- If your data already fits comfortably and your queries already feel fast, this changes nothing. Time one real query before you spend the evening.
sudo apt install -y gnupg postgresql-common apt-transport-https lsb-release wget
echo "deb https://packagecloud.io/timescale/timescaledb/ubuntu/ $(lsb_release -cs) main" | sudo tee /etc/apt/sources.list.d/timescaledb.list
wget --quiet -O - https://packagecloud.io/timescale/timescaledb/gpgkey | sudo gpg --dearmor -o /etc/apt/trusted.gpg.d/timescaledb.gpg
sudo apt update
sudo apt install -y timescaledb-2-postgresql-16
sudo timescaledb-tune
sudo systemctl restart postgresql
# Then, inside psql, on a COPY of your database first:
# CREATE EXTENSION IF NOT EXISTS timescaledb;
# SELECT create_hypertable('candles', 'time', migrate_data => true);