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

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.

Applicable in CAST Version

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 :

Notes / Comments

Related Pages

  • No labels