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