FLUSH_REAPER_QUEUE

Deletes all of the data marked for deletion in the database. Use this function when you want to remove all of the data marked for deletion before the reaper performs its task.

Note: The reaper is a service task that deletes disk files.

Syntax

FLUSH_REAPER_QUEUE()

Privileges

Superuser

Examples

Removes all of the files that have been marked for deletion in the database:

=> SELECT FLUSH_REAPER_QUEUE();
                 FLUSH_REAPER_QUEUE                  
-----------------------------------------------------
 Finished deleting all the files in the reaper queue
(1 row)

See Also

CLEAN_COMMUNAL_STORAGE