Fix sequence cache population

By removing the new transaction, which was vulnerable to concurrent DDL, and not populating the cache until *after* commit, as that is vulnerable to duplicates due to failure.

Also move the sequence cache size from a constant in the Sequence class to a configuration value just to give a little knob for the time being.