Re: Multitenent architecture

2020-07-21 Thread Michel Pelletier
On Tue, Jul 21, 2020 at 7:47 AM Vasu Madhineni wrote: > Hi All, > > Our project uses each database for tenant, But how can we restrict > tenant resources? > Ex: Tenent1 has to use 20% resource and Tenent2 has to use 10% resource, > how can we restrict users like this. > See https://wiki.postgres

Re: Multitenent architecture

2020-07-21 Thread Vasu Madhineni
Hi All, Our project uses each database for tenant, But how can we restrict tenant resources? Ex: Tenent1 has to use 20% resource and Tenent2 has to use 10% resource, how can we restrict users like this. Thanks and Regards, Vasu Madhineni On Mon, Jun 8, 2020 at 2:50 PM Laurenz Albe wrote: > On

Re: Multitenent architecture

2020-06-10 Thread Achilleas Mantzios
On 4/6/20 6:52 μ.μ., Vasu Madhineni wrote: Hi All, 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. Hello, you may benefit from this blog post : https://severalnines.com/database-blog/mul

Re: Multitenent architecture

2020-06-08 Thread Vasu Madhineni
Hi All, Thanks a lot for information, I will look into it and get back to you. Regards, Vasu Madhineni On Sun, Jun 7, 2020 at 1:21 AM Michel Pelletier wrote: > > On Sat, Jun 6, 2020 at 3:14 AM Vasu Madhineni > wrote: > >> Hi Rob, >> >> Our environment is medical clinical data, so each clinic

Re: Multitenent architecture

2020-06-07 Thread Laurenz Albe
On Sat, 2020-06-06 at 11:56 +0800, Vasu Madhineni wrote: > > > On Fri, Jun 5, 2020 at 2:57 PM Laurenz Albe > > > 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 > > > > > h

Re: Multitenent architecture

2020-06-06 Thread Jonathan Strong
Hi guys - apologies for jumping into the middle of this, but it touches on precisely one of the topics I'll have to deal with soon. We're standing up a pharmacovigilance / drug safety platform managing ICSRs (HL7 "individual case safety reports" that must be FDA/ICH compliant) and will be dealing w

Re: Multitenent architecture

2020-06-06 Thread Michel Pelletier
On Sat, Jun 6, 2020 at 3:14 AM Vasu Madhineni wrote: > Hi Rob, > > Our environment is medical clinical data, so each clinic as a tenant. > Approximately 500+ tenants with 6TB data. > > Thank you in advance. > > There's a good article on the AWS blog on multi tenancy with postgres: https://aws.am

Re: Multitenent architecture

2020-06-06 Thread Vasu Madhineni
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 wrote: > > > On Jun 5, 2020, at 2:54 AM, Vasu Madhineni wrote: > >  > If the data

Re: Multitenent architecture

2020-06-05 Thread Rob Sargent
> On Jun 5, 2020, at 9:57 PM, Vasu Madhineni wrote: > >  > Hi Rob, > > Our environment is medical clinical data, so each clinic as a tenant. > Approximately 500+ tenants with 6TB data. > . How quickly are both those numbers growing? What are your cross clinic query requirements ? Any sin

Re: Multitenent architecture

2020-06-05 Thread Ravi Krishna
> > 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.

Re: Multitenent architecture

2020-06-05 Thread Rob Sargent
> On Jun 5, 2020, at 2:54 AM, Vasu Madhineni wrote: > >  > If the data size is more than 6TB, which approach better? > >> On Fri, Jun 5, 2020 at 2:57 PM Laurenz Albe wrote: >> On Thu, 2020-06-04 at 23:52 +0800, Vasu Madhineni wrote: >> > We are planning a POC on multitenant architecture in P

Re: Multitenent architecture

2020-06-05 Thread Vasu Madhineni
If the data size is more than 6TB, which approach better? On Fri, Jun 5, 2020 at 2:57 PM Laurenz Albe 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 usi

Re: Multitenent architecture

2020-06-04 Thread Laurenz Albe
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 "sea

Re: Multitenent architecture

2020-06-04 Thread Paul Förster
Hi Vasu, > On 04. Jun, 2020, at 17:52, 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. look up the docs for "create database" and "create schema": https://ww

Multitenent architecture

2020-06-04 Thread Vasu Madhineni
Hi All, 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. Thank you so much all. Regards, Vasu