take long time to exec "optimize table xx purge"

[blade83lee]

i use golang ( "insert into xx" ) send data to databend continuously,
crontab 10 minutes "optimize table xx compact"
now i want to optimize table xx purge， it take long time

3 nodes databend-query 8C 16G

[blade83lee]

i have two large table

[blade83lee]

[blade83lee]

bug s3 have

so， why

[BohuTANG]

It's better to add limit to purge and run many times: OPTIMIZE TABLE t PURGE LIMIT 100