In practice, using async insert with wait means you need batching/retries implemented on the client side or else you may find you have thousands of threads stuc

In practice, using async insert with wait means you need batching/retries implemented on the client side or else you may find you have thousands of threads stuck in wait. If you need to replay bc you messed something up you're also SOL. I generally appreciate not having to run kafka but that comes at a cost.