RDBMS Information - CAST Storage Service - Maintenance of Database in CSS

This page gives you approach to solve performance issue in CASTStorageServce (Postgres)

For example: While running the snapshot , if any procedure is taking too much time to execute. Let say Procedure “DIT_MANY_DIRECTCALLTABLE” is taking to more than 15 hours to execute. Or any SQL query is running very slow in PGAdmin.

To apply the solution please follows below steps:

1. Open PGAdmin.
2. Right click on the postgres database and choose "Maintenance” option.
3. Select VACUUM option if not already selected.
4. Click OK .

Please check if below occurs in log please start the above procedure again.
ERROR: canceling autovacuum task.

For more information please refer : http://www.postgresql.org/docs/8.1/static/maintenance.html