Back to Reality in 2022

Following the disappointment of cancellation after cancellation in 2020 and 2021, real-life, in-person conferences are finally back on the agenda.

I'm honoured and excited to have had my talk "Divide and Conquer: Multi-tenancy in Postgres" accepted for both Nordic PGDay on 22 March 2022 and pgDay Paris on 24 March 2022. I can't wait to speak, to listen to the other sessions, and to interact with the PostgreSQL community.

I hope to see you in either Paris or Helsinki in March!

Talk Abstract:

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.