Database cleanup before PostgreSQL 18 upgrade: recommended retention period for log/statistics tables?

[Falco]

@scavin

ai_api_audit_logs 1.6 GB

You can control the retention period of this one using site settings.

@scavin

2. For tables like incoming_links, topic_views, and post_timings, do you normally keep all historical data, or periodically remove older records?

Those are meant to be kept forever, and they are usually the largest tables in most instances, so I wouldn’t worry about that.