[Maintenance] Re-enable optimize and snapshot expiry during backfill

[george-zubrienko]

Backfills that have lots of commits slow down due to metadata operations going over increasing number of files. We should run snapshot expiry and orphan file deletion + optimize on backfills, but not ANALYZE.