Re: Database Scalability

Поиск
Список
Период
Сортировка
От Ben Chobot
Тема Re: Database Scalability
Дата
Msg-id 145757b7-40b2-b189-fce4-06c7ca0c411d@silentmedia.com
обсуждение исходный текст
Ответ на Re: Database Scalability  (Mladen Gogala <gogala.mladen@gmail.com>)
Ответы Re: Database Scalability
Список 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 по дате отправления:

Предыдущее
От: Ben Chobot
Дата:
Сообщение: Re: Database Scalability
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Linux: directory change .../lib to .../lib64