FLUSH_REAPER_QUEUE

Eon Mode only

Deletes all data marked for deletion in the database. Use this function to remove all data marked for deletion before the reaper service deletes disk files.

Syntax

FLUSH_REAPER_QUEUE( [sync‑catalog] )

Parameters

sync‑catalog

Specifies to sync metadata in the database catalog on all nodes before the function executes:

  • true (default): Sync the database catalog
  • false: Run without syncing.

Privileges

Superuser

Examples

Remove all files that are marked for deletion:

=> SELECT FLUSH_REAPER_QUEUE();
                 FLUSH_REAPER_QUEUE                  
-----------------------------------------------------
 Sync'd catalog and deleted all files in the reaper queue.
(1 row)

See Also

CLEAN_COMMUNAL_STORAGE