Re: Encryption with customer provided key in a multi tenant Postgres JSONB DB

From: Michael Lewis <mlewis(at)entrata(dot)com>
To: Saurav Sarkar <saurav(dot)sarkar1(at)gmail(dot)com>
Cc: PostgreSQL General <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Re: Encryption with customer provided key in a multi tenant Postgres JSONB DB
Date: 2020-11-13 06:03:14
Message-ID: CAHOFxGrV-nVky381kJ=S-Z+L_9v-1E_U1FCu+iK-d=42Cj+ZDQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Wed, Nov 11, 2020 at 10:49 PM Saurav Sarkar <saurav(dot)sarkar1(at)gmail(dot)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.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Post Gresql 2020-11-13 07:29:26 Packages?
Previous Message Andreas Kretschmer 2020-11-12 19:23:06 Re: Is it possible to write a generic UPSERT?