You need to export 10 million rows. You paginate with OFFSET, fetching 1,000 rows at a time. The first batch takes 50ms. By batch 5,000 the offset is 5 million rows and each batch takes 30 seconds. The total job takes 6 hours and gets slower as it goes.
Your service elects a leader to run background jobs. The network hiccups for 5 seconds. The old leader thinks it's still leader. The new leader also thinks it's leader. Both start processing the same queue. Now you have duplicate work, corrupted state, and a split-brain.
LiveKit provides WebRTC infrastructure for voice agents and video. Combine with OpenAI Realtime API to build voice AI agents that listen and respond in real time.