Re: Database Scalability

Mladen Gogala wrote on 11/30/21 7:52 PM:
>
> To my knowledge PostgreSQL doesn't support sharding, which is well and 
> good because sharding is mostly useless, at least in my opinion.
>
OK I'll bite.

Not only does PostgreSQL natively support table partitioning (which is 
absolutely a form of sharding), there multiple well-regarded extensions 
that can help with sharding, all of which are orthogonal to how you can 
configure your application to use Postgres in the first place. So to say 
Postgres doesn't support sharding is.... misleading, at best.

Also, the general concept of sharding to move your scaling challenges 
from vertical ones to horizontal ones has multiple self-evident 
advantages. If your work history has all happened to fit on a single 
server, then bully for you, but not everybody has it so easy.