Re: Database Scalability - Mailing list pgsql-general

From Ben Chobot
Subject Re: Database Scalability
Date
Msg-id 145757b7-40b2-b189-fce4-06c7ca0c411d@silentmedia.com
Whole thread Raw
In response to Re: Database Scalability  (Mladen Gogala <gogala.mladen@gmail.com>)
Responses Re: Database Scalability  (SQL Padawan <sql_padawan@protonmail.com>)
List pgsql-general
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.



pgsql-general by date:

Previous
From: Ben Chobot
Date:
Subject: Re: Database Scalability
Next
From: Tom Lane
Date:
Subject: Re: Linux: directory change .../lib to .../lib64