Re: Multitenent architecture

From: Ravi Krishna <srkrishna(at)outlook(dot)com>
To: Vasu Madhineni <vasumdba1515(at)gmail(dot)com>
Cc: Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at>, PostgreSQL Mailing Lists <pgsql-general(at)postgresql(dot)org>
Subject: Re: Multitenent architecture
Date: 2020-06-05 10:14:42
Message-ID: 1406FDA1-E30C-4A46-9B8E-168B5B3BECB2@outlook.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

>
> If the data size is more than 6TB, which approach better?

Do you require cross tenants queries? If yes, then schemas are a better solution.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message David Rowley 2020-06-05 10:15:32 Re: Potential optimisation for the creation of a partial index condition over a newly created nullable, non-default-valued column?
Previous Message Oleksandr Shulgin 2020-06-05 10:11:54 Re: When to use PARTITION BY HASH?