Haas: Surviving Without A Superuser - Part One

Posted Dec 16, 2021 10:53 UTC (Thu) by nye (subscriber, #51576)
In reply to: Haas: Surviving Without A Superuser - Part One by Cyberax
Parent article: Haas: Surviving Without A Superuser - Part One

> We can’t do database-per-tenant or schema-per-tenant partitioning as this will blow up the complexity of all the routine operations like database upgrade

What sorts of things are you thinking of here? Things like updating the software version? Or more like data version migrations (whether schema updates or pure data)?

Haas: Surviving Without A Superuser - Part One

Posted Dec 16, 2021 19:14 UTC (Thu) by Cyberax (✭ supporter ✭, #52523) [Link]

Both. With potentially tens of thousands of tenants migrating each schema becomes problematic. We also occasionally need cross-tenant interactions and the tables are also partitioned.

It's all fixable of course, just kinda clumsy with multiple schemas.