Search
ctrl+/
Ask AI
ctrl+.
Light
Dark
System
Sign in

VacuumAdded in v5.0​

Reclaim storage space.

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

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.

statistics_update := {true | false}

If set to true, updates statistics used by the planner to determine the most efficient way to execute queries on specified data. See also administer statistics_update() (added in 6.0).

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();