[YSQL] [Connection Manager] Observed high NewOrder latencies in TPCC when using CM without Hikari and with long-lived logical connections.

[sonalsagarwal]

Jira Link: DB-14617

Description

Comparison Report :
TPCC 1000wh
TPCC 4000wh

YB version : 2024.2.1.0-b78
GFlags for connection Manager:

enable_ysql_conn_mgr = true
allowed_preview_flags_csv = enable_ysql_conn_mgr
ysql_conn_mgr_superuser_sticky = false

Issue Type

kind/bug

Warning: Please confirm that this issue does not contain any sensitive information

• I confirm this issue does not contain any sensitive information.