Today we deployed foundational changes for the introduction of our organisations feature. These included database schema changes which introduced additional levels of indirection for permission queries. While we were expecting an increase in database load for these queries, the actual load was higher than anticipated leading to a percentage of API requests to be dropped.

After analysing the cause of the higher load we identified some key database indexes that we added to our database. Furthermore we optimised some of the problematic permission queries.