Create pipeline that will execute Autovacuum freezee
The idea is to check for tables that are candidates for AUTOVACUUM FREEZE.
We should consider 70% of the autovacuum_freeze_max_age. We should trigger in tables that are larger than 10 GB.
To execute this process we need to define 2 steps:
- Collect the tables that we should autovacuum. This info should be collected from the production cluster.
- Start the jobs of AUTOVACUUM FREEZE for those tables. We should execute linear, and pause between executions. The original idea is execute this from 22:00 UTC until 06:00
Acceptance criteria:
-
Create a service account and corresponding ssh keys for staging and production ssh access. -
Create the process and rollout in staging. -
Create monitoring, alerts and runbooks for this process. -
Create the process and rollout in production.
Edited by Nels Nelson