Hello, Having a database with massive writes and updates, its file (and views) get huge and fragmented. Even a daily compaction takes few hours, and we cannot allow pausing these updates as users count on latest information.
So we need some kind of online cleanup... I wonder it we could somehow copy files to a side database, run compaction, replicate latest changes and swap databases. Can anyone recommend a procedure? Thanks!
