We are running timescale pg_prometheus with separating each services in schema. So in one database we have:
> >> schema_a > view: metrics > tables: metrics_copy, metrics_labels, metrics_values > >> schema_b > view: metrics > tables: metrics_copy, metrics_labels, metrics_values > and so on We have multiple databases with size: > datname size age(datfrozenxid) > ------------------------------------------ > postgres 8973 kB 51018138 > testdb 9165 kB 51018138 > template1 7649 kB 51018138 > template0 7473 kB 51018138 > testdb1 7781 kB 51018138 > db1 6334 MB 51018138 > db2 74 MB 51018138 > db3 9645 kB 51018138 > db4 11 MB 51018138 > db4 759 MB 51018138 We have only 25 days of data and are also using a materialized view. I am using the following query to check my emergency autovacuum threshold: > select ROUND(100*(max(age(datfrozenxid))/( > ( select setting AS value FROM pg_catalog.pg_settings WHERE name = > 'autovacuum_freeze_max_age' ))::float) > ) as percent_towards_wraparound > from pg_database Now each day I can see it is growing towards the limit. Now it is showing 26%. How can we save our system from wraparound issue? Someone please give some suggestions. Thanks.
