In our multitenant system we have 200+ Databases ,
We started with v19.1.5 and performance was better till we migrated it to v20.1.17 .
A query which usually takes half a second in v19.1.5 is taking over minutes to complete in v20.1.17.
- high latency
- slow queries. taking minutes to complete one.(for example a “show tables;” query in any data base is taking a minute or more )
- memory always above 80 or 90 percent in nodes
- Dbeaver client it taking significant amount of time to load data when connected to cluster
Is there any hotfix ,configuration changes that need to be done to make it better?
I have posted the same in Polynomial latency growth for database isolated ("Bridge") multi-tenant models · Issue #63206 · cockroachdb/cockroach · GitHub
is this due to any architecture limitation?