add_retention_polict_to_outbox.sql

create table my_outbox
(
    id      serial,
    data    jsonb                                   not null,
    created timestamp with time zone default now() not null,
    primary key (id, created)
);

insert into my_outbox (data, created)
values ('{"a": 1}'::jsonb, default),
       ('{"a": 2}'::jsonb, now() - interval '10 days');

create extension if not exists timescaledb;

select create_hypertable(relation =>'my_outbox',
                         time_column_name => 'created',
                         chunk_time_interval => interval '1 day',
                         migrate_data => true);

-- select show_chunks('my_outbox');

SELECT add_retention_policy('my_outbox', interval '7 days');

-- select * from timescaledb_information.jobs where proc_name = 'policy_retention';