CRS Windows : searching recording very slow

Doc ID		SOLN269596
Version:		3.0
Status:		Published
Published date:		08 Oct 2015
Created Date:		03 Jun 2015

Author:

chengdongzhao

Details

ACR/CRS version 1200119.
There're Master/Standby ACR installed in Linux platform, CRS server installed in Windows platform. When do searching recording from ACR server, it return value very quick (less than 1s), but when do searching in CRS, it need 10-30s or more to get result.

Problem Clarification

Login CRS with admin user and do a searching for 1 day or 7 days or 30 days. All these searching need dozens of seconds to get searching result.
Copy out the same SQL sentence and launch from Postgres DB, it's the same.

Cause

ACR server is in Linux platform and CRS server is in Windows platform. the default statistics target for table columns on CRS Windows platform is set with 10 by default. It need improve the quality of the planner's estimates with the setting.

Solution

From CRS Windows platform, access Postgresql DB with command "psql -U eware -h localhost -p 6432";
Run SQL "select * from pg_settings where name = 'default_statistics_target';" to check the setting, the setting is 10 by default.
Run below SQL to set it with 100:
set default_statistics_target to 100;
analyze;
After this setting, CRS searching function become very quick (31 days searching can get result in 1s);

Avaya -- Proprietary. Use pursuant to the terms of your signed agreement or Avaya policy