#!/bin/bash

echo "DROP TABLE IF EXISTS tbl;"
echo "CREATE TABLE tbl(id int);"
echo "INSERT INTO tbl SELECT g FROM generate_series(1, 100000) g;"

echo "BEGIN;"
echo "\timing"
for ((i = 0; i < 1000; i++))
do
    echo "SAVEPOINT sp$i;"
    echo "DELETE FROM tbl WHERE id % 1000 = $i;"
done
echo "ROLLBACK;"