I also think database specific backup makes more sense. Some people recommend filesystem snapshotting but wouldn't that make recovery a slow process because yo

I also think database specific backup makes more sense. Some people recommend filesystem snapshotting but wouldn't that make recovery a slow process because you have to load up the entire database even if you just wanted to look up on data of a small table? Maybe backing up only small tables as SQL dumps while keeping a file system snapshot would be a good compromise.