Distributed AN Cluster?

TimescaleDB and PostgreSQL
1

Hello,

Is there any way to horizontally scale the TimescaleDB Access Node (AN-primary node)?
Most resources talk about vertical scaling for the AN, but that’s not exactly what I’m looking for.
What I really want is to distribute write loads across the cluster in a more scalable way.

I’m curious—how can I set up such a distributed cluster?"

2

Note: I’m using Kubernetes.

3

Hi Anil, I think you can use external tools like pg_dog.

I did a small example setup here and it just works.

1 Like
4

I’m new to using PostgreSQL and TimescaleDB.
Since I’ve mainly worked with NoSQL databases until now, I’d like to ask a question:

When setting up a cluster from scratch, should we first implement sharding using pgShard (or a similar method), and only then activate TimescaleDB?

Also, does TimescaleDB operate with just a single access node? If so, how is consistency maintained across multiple nodes?

5

Timescaledb primary operates on a single node. The Timescale (the company) stopped the distributed hypertables because we went into another strategy using single-node and tiered storage. You can see more details here: You Too Can Scale Postgres to 2 PB and 1 T Metrics per Day | Timescale