On this page
Warning:
As of November 18, 2022, CockroachDB v21.1 is no longer supported. For more details, refer to the Release Support Policy.
This page provides recipes for fixing performance issues in your clusters.
Note:
If you aren't sure whether SQL query performance needs to be improved on your cluster, see Identify slow queries.
Problem | Possible solution |
---|---|
Your application is experiencing high latency. | Use the correct topology pattern for your cluster to minimize network latency. |
|
Your workload is experiencing contention |
|
Poor quality statement plans retrieve more rows than are required, leading to longer execution times |
|
Your tables may be using a suboptimal primary key, causing resource contention |