[pixels-load] compact tail files and support arbitrary storage.

[bianhq]

Currently, the tail files are ignored in compaction.
This is not a bug, but for the TPC-H evaluations, we need to compact the tail files.

Moreover, compact should support compacting files in arbitrary storage.