[DEPRECATED] Promscale is a unified metric and trace observability backend for Prometheus, Jaeger and OpenTelemetry built on PostgreSQL and TimescaleDB.
Take the oldest age from the chunks to vacuum view let's call this AGE.
if AGE < vacuum_freeze_min_age do nothing. Use the db vacuum_freeze_min_agesetting not the table setting (the table setting is 0). Hoping autovac takes care of things.
if AGE > vacuum_freeze_min_age then linearly interpolate the AGE between vacuum_freeze_min_age and autovacuum_freeze_max_age and apply that interpolation to the number of vacuum workers so if AGE = vacuum_freeze_min_age use 1 worker and if AGE=`autovacuum_freeze_max_age use the max number of workers configured
Instead of using vacuum_freeze_min_age and autovacuum_freeze_max_age we can also have the min and max age configured through CLI options. Not sure what's better
jgpruitt
commented
2 years ago
Take the oldest age from the chunks to vacuum view let's call this AGE. if AGE < vacuum_freeze_min_age do nothing. Use the db vacuum_freeze_min_agesetting not the table setting (the table setting is 0). Hoping autovac takes care of things. if AGE > vacuum_freeze_min_age then linearly interpolate the AGE between
vacuum_freeze_min_ageand autovacuum_freeze_max_age and apply that interpolation to the number of vacuum workers so if AGE = vacuum_freeze_min_age use 1 worker and if AGE=`autovacuum_freeze_max_age use the max number of workers configuredInstead of using vacuum_freeze_min_age and autovacuum_freeze_max_age we can also have the min and max age configured through CLI options. Not sure what's better