While flush_tier is pushing work units for the internal thread to copy to the shared storage, it would be useful to provide an API as well as a synchronous configuration setting to have it wait for that to finish.

The API may be something similar to session->transaction_sync. The configuration setting may be an internal version of that where the user's flush_tier thread waits (on something not yet defined) that the worker thread will signal when it is done.