purge_old_deltas.sql

DO $$
DECLARE
    target TEXT;
BEGIN
    FOR target IN
        SELECT table_name
          FROM information_schema.tables
         WHERE table_schema = 'bucardo'
           AND table_name LIKE 'track_%'
    LOOP
        EXECUTE format(
            'DELETE FROM bucardo.%I WHERE txntime < %L',
            target, NOW() - '30 DAYS'::interval
        );
        EXECUTE format(
            'DELETE FROM bucardo.%I WHERE txntime < %L',
             replace(target, 'track', 'delta'),
             NOW() - '30 DAYS'::interval
        );
    END LOOP;
END;
$$;