Over time and through continued use, the efficiency of your Application's CAST AIP schemas may well start to degrade ("gaps" in table data, inefficient indexes etc.) - this degradation can significantly impact the performance of CAST AIP, with the most visible impact seen in the performance of the CAST Dashboards. To counter this, CAST provides a feature (known as CssOptimize) that can be run to optimize the schemas stored in your CAST Storage Service/PostgreSQL instance - i.e. to clean up defects that have appeared over time.
The CssOptimize tool can perform various different optimization actions, all of which are standard PostgreSQL actions:
|Disabled||This option disables all automatic optimization actions. Only for use when troubleshooting - otherwise not recommended since this can have a significant impact on performance of CAST Dashboards.|
|Analyze (default action)||See https://www.postgresql.org/docs/current/sql-analyze.html for more information on the actions performed.|
See https://www.postgresql.org/docs/current/sql-analyze.html for more information on the actions performed.
|Analyze and Vacuum|
This tool is run automatically with the default Analyze action in the following situations:
- immediately on completion of a snapshot
- immediately on completion of a data upload to the Measurement schema
If you would like to change the default action (for example change to Analyze and Vacuum, or to disable the action entirely), choose the option you require in the drop down list.
The optimize actions can also be run manually:
- via the AIP Console GUI:
- using command line tools: