2 ms·

I'm wondering if there is a way to use Timescale in combination with Citus. We are well adjusted to Citus as we're using now for almost 2 years. For most data

by doh 9y ago

I'm wondering if there is a way to use Timescale in combination with Citus. We are well adjusted to Citus as we're using now for almost 2 years. For most data it's great but we do have some time series data where we have to do a lot manually to achieve desirable results. I'm wondering if there is a way to take advantage of both, but not sure how would the query distribution work in combination of the two.

craigkerstiens 9y ago
Craig from Citus here. Its a question we get quite often. Unfortunately, I'm actually not sure. There is a chance they would play just fine together, and from a quick glance they likely would but we've not explored this ourselves yet. Since Citus would be running on the coordinator you'd place timescale on each distributed node and at that point what Citus passes down is standard SQL which timescale can act on. All that said we've not heavily tested it ourselves and there would be some open questions on designing the right experience. We do have a number of users that are using Citus alongside the native time partitioning that was released in Postgres 10 with good results. Edit: We also had this blog post in our pipeline that speaks to time partitioning with Citus which just went live today - https://www.citusdata.com/blog/2018/01/24/citus-and-pg-partman-creating-a-scalable-time-series-database-on-PostgreSQL/ https://www.citusdata.com/blog/2018/01/24/citus-and-pg-partm...