delete_test_data.sql

gistfile1.sql

create or replace function delete_test_data(chunk int,sleep int) returns void as $$                                                                                     
declare                                                                                                                                                                 
chunk int := $1;                                                                                                                                                        
sleep_interval int := $2;                                                                                                                                               
deleted_rows int;                                                                                                                                                       
begin                                                                                                                                                                   
while deleted_rows != 0 or deleted_rows is null loop                                                                                                                    
  delete from products where id in (select id from worktable order by id limit chunk);                                                                                  
  delete from worktable where id in (select id from worktable order by id limit chunk);
  get diagnostics deleted_rows := row_count;
  perform pg_sleep(sleep_interval);
  raise notice 'deleted % rows', deleted_rows;
end loop;  
end;
$$ language plpgsql