In the great SaaS world we live in now, we see more and more multi-tenant systems. When it's not too late to weigh in the design of the database for these setups, you face several options. Choose wisely, there will be no turning back. After working for about 10 years as a more or less official DBA in several companies, I have faced several implementations of multi-tenant databases, and seen several benefits and drawbacks of them. In this presentation, I would like thus to give an introduction to what multi-tenant databases are, how they can be implemented, and how they can come back haunt you.
This talk will include, but not limited to: - patches that had to be written for PG to work around the drawbacks of some choices (and because, if I dare say, PostgreSQL is not perfect), - how lonely you can feel when many PG tools are made unusable, - mathematically proven optimization pain, - some humor to lighten things up.
The following slides have been made available for this session: