Sample Header Ad - 728x90

Is there a reason why anti-wraparound autovacuum took around 42000 seconds to complete?

0 votes
0 answers
34 views
I have default auto-vacuum settings as follows - pg_settings Autovacuum is running on a table with high-volume of insert operations. I have also applied a table-specific setting of autovacuum_freeze_max_age to 100000. Is there any setting I need to tweak to fix this? 42000 seconds sounds ridiculous. Please note that I am using postgreSQL 12.
Asked by Yashodhan Agnihotri (11 rep)
Mar 9, 2025, 10:08 AM