Understanding Database Optimization

A daily process physically removes unused data from the database on a configurable schedule.

In normal PostgreSQL operation, a tuple (sequence of terms) that is deleted or obsoleted by an update is not physically removed from the table; storage space is occupied by "dead" tuples until a 'VACUUM' procedure is performed. A vacuum procedure should be performed periodically to optimize the database, especially on frequently-updated tables in the database.

Facility optimization needs vary, depending on database usage. By default in the Vocera Platform, a vacuum procedure is performed daily to optimize database performance. You can configure the date and time for the daily scheduled optimization, or change to a weekly schedule, in the Vocera Platform Web Console.