Re: Database Scalability

From: Michael Stephenson <domehead100(at)gmail(dot)com>
To: Mladen Gogala <gogala(dot)mladen(at)gmail(dot)com>
Cc: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: Database Scalability
Date: 2021-12-01 04:18:41
Message-ID: CF28D0B4-A761-4507-82E1-650F917FF76B@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Store a connection string for each tenant or the metadata to build one on demand. Then each tenant is in its own schema on whatever database instance the connection string points at. Then it doesn’t really matter how you spread your tenants across one database or many; just do whatever works best and adjust as needed.

~ Mike

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Garfield Lewis 2021-12-01 05:28:06 Re: [EXT] Re: XQuery/XPath 2.0+ support
Previous Message Mladen Gogala 2021-12-01 03:52:05 Re: Database Scalability