Batch delete database rows with transactions

sample.sql

begin;

\timing on
DELETE FROM
    account AS a
USING 
    member AS m
WHERE
    m.territory='XY' AND
    m.member_id >= (:v1 + 0) * 1000 AND
    m.member_id < (:v1 + 1) * 1000 AND    
    a.member_id = m.member_id
;
\timing off

commit;

script.sh

#!/bin/bash
set -euo pipefail

URL='postgres://...'
SQL_FILE='sample.sql'

# Batches of 1000
for i in {0..100000}; do
    id_=$((i*1000))
    echo "=== Batch #${i}. IDs > ${id_}."
    psql -v v1="${i}" -f $SQL_FILE $URL
done