Scaling Relational SQL Databases (2020)

Re:Scaling Relational SQL Databases (2020) by nivertech on Wednesday June 16, 2021 @10:26AM (#27528862)

Do you mean that TimescaleDB 2.0 can be used instead of Citus to scale general purpose (non just timeseries) workloads?

For example a multitenant workloads where you shard by org_id, etc.?

I actually thought about it, but wasn't aware about v2.0

[ Parent | on HN ]

Re:Scaling Relational SQL Databases (2020) by ryanbooz on Wednesday June 16, 2021 @02:12PM (#27531649)

Horizontal scaling within TimescaleDB is still geared around time-series data and (distributed) hypertables.

https://docs.timescale.com/timescaledb/latest/how-to-guides/...

[ Parent | on HN ]

Re:Scaling Relational SQL Databases (2020) by eatonphil on Wednesday June 16, 2021 @10:30AM (#27528909)

Our use case was OLAP workload and IIRC I don't think it's transaction support is great for horizontally scaling OLTP workloads. I wanted to call it out since the author mentioned timeseries data but didn't mention this aspect of Timescale. (Though to be fair, this feature of Timescale may have came out after the post was written.)

[ Parent | on HN ]

Re:Scaling Relational SQL Databases (2020) by petr25102018 on Wednesday June 16, 2021 @01:02PM (#27530801)

Thanks for the information. I wasn't aware of such feature at the time of writing the post.

[ Parent | on HN ]