I might suggest trying out the timescale extension's hypertable, which can greatly ease sharding over time (plus optionally one extra dimension). If you have in

I might suggest trying out the timescale extension's hypertable, which can greatly ease sharding over time (plus optionally one extra dimension). If you have infinitely growing data, having the data sharded might help managability & perhaps performance. https://docs.timescale.com/timescaledb/latest/overview/core-concepts/hypertables-and-chunks/ https://docs.timescale.com/timescaledb/latest/overview/core-...