Re: Database Scalability

From: Ben Chobot <bench(at)silentmedia(dot)com>
To: Saurav Sarkar <saurav(dot)sarkar1(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Database Scalability
Date: 2021-12-01 14:32:37
Message-ID: 607b41e4-9267-4ab5-378f-823722a10263@silentmedia.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Ben Chobot 2021-12-01 14:53:20 Re: Database Scalability
Previous Message Ron 2021-12-01 14:28:54 Re: Linux: directory change .../lib to .../lib64