It could be convenient to have bash for database cleanup like <a href="http

I think you should tweak <a href="https://docs.timescale.com/api/latest/data-retention

<a class="user-mention notranslate" data-hovercard-type="user" data-hovercard-url="/us

script to cleanup database about statsbit HOT 2 CLOSED

bia-technologies commented on June 12, 2024

script to cleanup database

from statsbit.

Comments (2)

darkleaf commented on June 12, 2024

I think you should tweak the retention policies.
Here are some examples for a test server and a prod server.

You can write your own migration and setup it with STATSBIT_BACKEND_MIGRATION_LOCATIONS as described in the readme file. Or you can simply execute the following commands:

select remove_retention_policy('metric-data', if_exists => true);
select add_retention_policy('metric-data', interval '1 month');

select remove_retention_policy('transaction-sample-data', if_exists => true);
select add_retention_policy('transaction-sample-data', interval '1 month');

select remove_retention_policy('analytic-event-data', if_exists => true);
select add_retention_policy('analytic-event-data', interval '1 month');

select remove_retention_policy('error-data', if_exists => true);
select add_retention_policy('error-data', interval '1 month');