Re: Multitenent architecture - Mailing list pgsql-general

From Ravi Krishna
Subject Re: Multitenent architecture
Date
Msg-id 1406FDA1-E30C-4A46-9B8E-168B5B3BECB2@outlook.com
Whole thread Raw
In response to Re: Multitenent architecture  (Vasu Madhineni <vasumdba1515@gmail.com>)
List 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.


pgsql-general by date:

Previous
From: Oleksandr Shulgin
Date:
Subject: Re: When to use PARTITION BY HASH?
Next
From: David Rowley
Date:
Subject: Re: Potential optimisation for the creation of a partial indexcondition over a newly created nullable, non-default-valued column?