Symfoware Server does not immediately delete the updated or deleted data. If the VACUUM determines there are no transactions that reference the database, Symfoware Server collects obsolete data.
However, obsolete data is not collected if there are connections that have remained active for an extended period or connections occupying resources. In this case the database may expand, causing performance degradation.
See
Refer to "Routine Vacuuming" under "Server Administration" in the PostgreSQL Documentation for information on the VACUUM command.
In such cases, you can minimize performance degradation of the database by monitoring problematic connections.
The following two methods are supported for monitoring connections that have been in the waiting status for an extended period:
