I did defrag the database using urbackupsrv, that did take about a day.
Now it’s rebuilding from scratch the whole file index, it made about 10% in 24h.
I think after every defrag, it rebuild everything. But today, 10 days without backup is not very reasonable.
Is it possible to skip that part even if more files have to be re-transfered then resume it later ?
So i can do something like 1 day backup then 1 day reindex.
Can the database be split by date or client+common files (partitioned tables) so a live reindex can be envisioned?
My guess is that as it is , the file index is too big to be manageable. And somehow, there’s a need for splitting it, even at some cost like not allowing a few specific clients to backup for a few days. Or having these client retransfert the full files while the reindex is progressing.