Postgres multiple tenant performance

Hi, What we are observing is that once we add more tenants, the performance of APIs are getting very slow. e.g. complete task starts taking 25+ seconds when we add @20 tenants instead of 2 seconds what we are observing with 1 tenant.
Anyone has any experience with similar issues. Please let me know.

2 Likes

it seems, we have added partition on tenant id for all act_hi and act_ru tables. It seems that Camunda does not have tenant_id_ column in all its queries (where clauses) its making it slow. Is there any setting which will make Camunda add tenant id to all its queries. That I think will make it faster.
If anyone has any suggestions please let me know.