2 ms·
I'm currently getting started with TimescaleDB for storing lots of time-series data (all the public data from cryptocurrency exchanges). Turns out, there's a b
by hmsimha 6y ago
I'm currently getting started with TimescaleDB for storing lots of time-series data (all the public data from cryptocurrency exchanges).
Turns out, there's a bit of weird stuff required in order to collect orderbook data, which involves recording updates, but also the 'full state' (or at least as much as I can get) periodically. The current plan is to add an interface between the DB and the consumers that makes it work a bit like a temporal table (if we're storing the full state at the beginning of every hour, the previous state along with any updates should expire at the end of the hour).
If postgres could also leverage the temporal tables extension we might prevent needing to store a lot of entries that 'invalidate' previous entries, but then I imagine there's internal overhead with the temporal tables extension as it manages expiry time.
I'm wondering, are there any notes on using the temporal tables extension with the timescaledb extension? Wondering if that's something worth investigating.