BEGIN; WITH batch AS ( SELECT id FROM orders WHERE status IS NULL ORDER BY id LIMIT 5000 ) UPDATE orders o SET status = 'pending' FROM batch WHERE o.id = batch.id; COMMIT; SELECT pg_sleep(0.5);