Add cache invalidation worker (cronjob) to compose and OCP manifests

oss-aspen / 8Knot

Dash app in development to serve open source community visualizations using GitHub data from Augur. Hosted app: https://eightknot.osci.io

MIT License

46 stars 59 forks source link

Add cache invalidation worker (cronjob) to compose and OCP manifests #552

Open JamesKunstle opened 8 months ago

JamesKunstle commented 8 months ago

Postgres doesn't automatically evict "stale" data, so we need to write a small script that'll check the TTL of cached data across all tables in cache and delete those rows.

TTL metadata is available in bookkeeping table, respective of (table, repo_id).

JamesKunstle commented 7 months ago

For time being, restarting cluster to solve this problem.