3 ms·
Yeah, to underscore some differences more completely, timescale has: - Full indexing and secondary index support. - Support for transactional semantics - Sup
by cevian 9y ago
Yeah, to underscore some differences more completely, timescale has:
- Full indexing and secondary index support.
- Support for transactional semantics
- Support for living along side relational data - including foreign keys to the relational data.
- Full trigger and constraint support
- Support for all of Postgres's native data types including JSON(B) and GIS location data.
- amelius 9y agoTransactional support? I was under the impression that timeseries data is considered immutable.
- grzm 9y agoBeing transactional is orthogonal to being immutable. For example, if you want to ensure that a given set of writes is applied atomically, you would issue them in a transaction.
- mfreed 9y agoThis is especially important if you are also dealing with metadata that you don't want to always denormalize into your time-series tables. If you don't insert it transactionally, you can also lose referential integrity between your time-series and relational (metadata) tables.
- cevian 9y agoThat's not always true. There are tons of cases where time-series data gets corrected later. It is true that time-series is INSERT-mostly but UPDATES do happen.