4 ms·
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
by 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...