zlacker

[return to "Postgres Postmaster does not scale"]
1. athert+V32[view] [source] 2026-02-05 04:55:50
>>davidg+(OP)
I'm a bit confused here, do they have a single database they're writing to? Wouldn't it be easier and more reliable to shard the data per customer?
◧◩
2. thayne+8k2[view] [source] 2026-02-05 07:36:51
>>athert+V32
Sharding is often not easy. Depending on the application, it may add significant complexity to the application. For example, what do you do if you have data related to multiple customers? How do you handle customers of significantly different sizes?

And that is assuming you have a solution for things like balancing, and routing to the correct shard.

[go to top]