3 ms·
> One thing missing from your post is any information on workload. What kind of data are you storing, what kind of use are you expecting,... it's hard to make r
by _448 4y ago
> One thing missing from your post is any information on workload. What kind of data are you storing, what kind of use are you expecting,... it's hard to make recommendatuons in the abstract.
I am designing an entity-relation type system that is append-only for audit purposes. The system will have various apps and users will be authorised to use certain apps.
- rektide 4y agoI 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-...