[gpfsug-discuss] Quick delete of huge tree

[Ulrich Sibiller]

On 4/20/21 1:52 PM, Jan-Frode Myklebust wrote:
> A couple of ideas.
> 
> The KC recommends adding WEIGHT(DIRECTORY_HASH) to group deletions within a directory. Then maybe > also do it as a 2-step process, in the same policy run. Where you delete all non-directories first,
> and then deletes the directories in a depth-first order using WEIGTH(Length(PATH_NAME)):
> 
> 
> RULE 'delnondir' DELETE
> WEIGHT(DIRECTORY_HASH)
>       DIRECTORIES_PLUS
>       WHERE PATH_NAME LIKE '/mypath/%' AND NOT MISC_ATTRIBUTES LIKE '%D%'
> 
> RULE 'deldir' DELETE
>       DIRECTORIES_PLUS
>      WEIGHT(Length(PATH_NAME))
>       WHERE PATH_NAME LIKE '/mypath/%'  AND MISC_ATTRIBUTES LIKE '%D%'


Thanks, I am aware of that but it will not really help with my speed concerns.

Uli


-- 
Dipl.-Inf. Ulrich Sibiller           science + computing ag
System Administration                    Hagellocher Weg 73
Hotline +49 7071 9457 681          72070 Tuebingen, Germany
                           https://atos.net/de/deutschland/sc
-- 
Science + Computing AG
Vorstandsvorsitzender/Chairman of the board of management:
Dr. Martin Matzke
Vorstand/Board of Management:
Matthias Schempp, Sabine Hohenstein
Vorsitzender des Aufsichtsrats/
Chairman of the Supervisory Board:
Philippe Miltin
Aufsichtsrat/Supervisory Board:
Martin Wibbe, Ursula Morgenstern
Sitz/Registered Office: Tuebingen
Registergericht/Registration Court: Stuttgart
Registernummer/Commercial Register No.: HRB 382196