VacuumNew

Reclaim storage space.

administer vacuum "("
  [type_link_or_property [, ...]]
  [, full := {true | false}]
")"

Description

Cleans and reclaims storage by removing obsolete data.

type_link_or_property: If a type name or a path to a link or property are specified, that data will be targeted for the vacuum operation. If omitted, all user-accessible data will be targeted.
full := {true | false}: If set to true, an exclusive lock is obtained and reclaimed space is returned to the operating system. If set to false or if not set, the command can operate alongside normal reading and writing of the database and reclaimed space is kept available for reuse in the database, reducing the rate of growth of the database.

Vacuum the type SomeType:

Copy

administer vacuum(SomeType);

Vacuum the type SomeType and the link OtherType.ptr and return reclaimed space to the operating system:

Copy

administer vacuum(SomeType, OtherType.ptr, full := true);

Vacuum everything that is user-accessible in the database:

Copy

administer vacuum();