If I create an account on a small instance and that instance shuts down, will I not lose my account and post history?

You might want to re-read that table.