I've had an interesting experience a couple times this week. I fire up the empty node to test something, then I work for a while, then I notice it's stalled. Then I notice it's not actually stalled, it's fully synced.
Sure. There is no automatic table sizing or automatic snapshotting presently, but you can configure for it. The big issue you'd hit is paging with tables that exceed your RAM.