Re: Encryption with customer provided key in a multi tenant Postgres JSONB DB - Mailing list pgsql-general

From Michael Lewis
Subject Re: Encryption with customer provided key in a multi tenant Postgres JSONB DB
Date
Msg-id CAHOFxGrV-nVky381kJ=S-Z+L_9v-1E_U1FCu+iK-d=42Cj+ZDQ@mail.gmail.com
Whole thread Raw
In response to Encryption with customer provided key in a multi tenant Postgres JSONB DB  (Saurav Sarkar <saurav.sarkar1@gmail.com>)
List pgsql-general
On Wed, Nov 11, 2020 at 10:49 PM Saurav Sarkar <saurav.sarkar1@gmail.com> wrote:

We have a multi tenant application where for each tenant we create separate tables . So for e.g. if i have 100 tenants then i have 100 tables.


Depending how many tables each client gets and what you expect your tenant growth may be like, you will likely need to consider separate databases at some point for better stats and to ensure the system handles catalog table lookups and such.

pgsql-general by date:

Previous
From: Andreas Kretschmer
Date:
Subject: Re: Is it possible to write a generic UPSERT?
Next
From: Post Gresql
Date:
Subject: Packages?