Setting up a distributed database with TimescaleDB

Question

I am working on a project that uses TimescaleDB as a database storage for data that is about 6 TB in size. It is setup as an instance on AWS EC2.

If I understand clearly, TimescaleDB has the concept of Hypertables which basically performs chunking behind the scenes to emulate distributed environment.

I wanted to know if it is possible to create a distributed environment, possibly using 3 instances as a cluster, and splitting data storage across these three nodes, so 6 TB is distributed as 2 TB on each instance.

Is this is something that is possible on the current version (1.7.2)?

Answer 1

TimescaleDB 2.0 will support "horizontal sharding" of data, as you suggest, as part of its distributed hypertables.

We expect 2.0-RC1 to be out this week, and each release candidate will be "fully upgradeable" to the final 2.0 release.

For detailed information about TimescaleDB multi-node and distributed hypertables, please see this blog post last year (since then, we've had six beta releases, starting last fall).

• General architecture, insert scaling: https://blog.timescale.com/blog/building-a-distributed-time-series-database-on-postgresql/
• Query performance through pushdown: https://blog.timescale.com/blog/achieving-optimal-query-performance-with-a-distributed-time-series-database-on-postgresql/