Conference Schedule - pgDay Paris 2022

Divide and Conquer: Multi-tenancy in Postgres

Date: Thursday, March 24, 2022
Time: 10:20–11:05

Most organizations or database teams don't have the luxury of looking after just a single database application. Some will manage at least a few applications, others will have hundreds. In most organizations, the question of multi-tenancy will therefore probably arise.

The Postgres environment can be designed in various different ways to accommodate multiple customers and/or applications. For example: - each application could have its own Postgres cluster - we could create a separate database per application within a shared cluster - we could create a single database that contains a separate schema per application - we may allow multiple customers to share a single schema, with the (shared) tables partitioned by customer

But which of these is the “right” option?

The answer is, as always, “it depends”. The correct method is the one that provides the required balance between performance, security, high availability and manageability.

In this presentation, we'll look at the different multi-tenant architectures and the advantages and disadvantages of each. It should enable you to design the most appropriate database environment for your applications.

Slides

The following slides have been made available for this session:

Speaker

Karen Jex