This panel is only visible in Console 1.x. In more recent releases, the panel has been merged with CAST Storage Service/Measurement settings. See Administration Center - Settings - CSS and Measurement settings.
Over time and through continued use, the efficiency of your Application's schemas may well start to degrade ("gaps" in table data, inefficient indexes etc.) - this degradation can significantly impact performance 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. |
| 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:
- via the Console GUI:
- Administration Center - Settings - Measurement (for the Measurement schema)
- Administration Center - Applications (for the Application schemas)
- using command line tools:
