Re: Database Scalability

Поиск
Список
Период
Сортировка
От Ben Chobot
Тема Re: Database Scalability
Дата
Msg-id 607b41e4-9267-4ab5-378f-823722a10263@silentmedia.com
обсуждение исходный текст
Ответ на Re: Database Scalability  (Saurav Sarkar <saurav.sarkar1@gmail.com>)
Список pgsql-general
Saurav Sarkar wrote on 11/30/21 7:08 PM:
> So are all the schemas on one DB or are distributed/sharded across 
> multiple DBs ?
In our use case, every db entirely homes one or more schemas. Some dbs 
host many schemas for small customers, some dbs host a handful of 
schemas for medium customers, and some dbs are dedicated to a single 
large customer. If the customer is very large, we get a bigger db than 
normal for them. So theoretically we still have a problem of vertical 
scale but in practice it's rarely an issue and when it is, we can 
usually split that single customer into multiple, at the application layer.



В списке pgsql-general по дате отправления:

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