FLUSH_REAPER_QUEUE

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