Delete large number of rows from very large sql tables

cleanup.py

from sqlalchemy import create_engine
from functools import reduce
import minibar
import time
import ast
import os

eng = create_engine(os.getenv('db_config'))
table = x
take = 10000
run = 1000
total = run * take
template = "{i}/{total} {bar} {elapsed}s {eta}" # Progress bar template

print(f"Deleting {total} records")

for i in minibar.bar(range(run), template=template):
    # Connect to DB
    connection = eng.connect()
    # Row IDs to be deleted
    sql_id = f"""SELECT id from {table} ORDER BY id desc limit {take}"""
    ids = connection.execute(sql_id).fetchall()
    resultset = [tuple(row) for row in ids]
    list = reduce(lambda x,y: x+y, resultset)
    # Delete rows from table
    sql = f"""DELETE FROM {table} where id in {list}"""
    connection.execute(sql)
    # Close connection
    connection.close()