Page tree
Skip to end of metadata
Go to start of metadata

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:

DisabledThis 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.
Vacuum

See https://www.postgresql.org/docs/current/sql-analyze.html for more information on the actions performed.

Analyze and Vacuum
Full 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:

  • No labels