Hi Rob, Our environment is medical clinical data, so each clinic as a tenant. Approximately 500+ tenants with 6TB data.
Thank you in advance. Regards, Vasu Madhineni On Fri, Jun 5, 2020 at 6:09 PM Rob Sargent <robjsarg...@gmail.com> wrote: > > > On Jun 5, 2020, at 2:54 AM, Vasu Madhineni <vasumdba1...@gmail.com> wrote: > > > If the data size is more than 6TB, which approach better? > > On Fri, Jun 5, 2020 at 2:57 PM Laurenz Albe <laurenz.a...@cybertec.at> > wrote: > >> On Thu, 2020-06-04 at 23:52 +0800, Vasu Madhineni wrote: >> > We are planning a POC on multitenant architecture in Postgres, Could >> you please >> > help us with steps for multitenant using schema for each application >> model. >> >> For few tenants, you can keep identical tables in several schemas and >> set "search_path" to select a tenant. >> >> With many tenants, you are better off with one table that holds the >> data for all clients. You can use Row Level Security to have each >> tenant see only his or her data, and it might be a good idea to >> use list partitioning on the tenant ID. >> >> Yours, >> Laurenz Albe >> -- >> Cybertec | https://www.cybertec-postgresql.com >> >> The question is How many separate data owners? >
