RE: Extremely slow autovacuum:vacuum to prevent wraparound

From: Rijo Roy [mailto:rjo_roy(at)yahoo(dot)com]
Sent: 11 July 2018 15:14
To: Steven Winfield
Cc: pgsql-general(at)postgresql(dot)org
Subject: RE: Extremely slow autovacuum:vacuum to prevent wraparound

Hi Steve,

Apologies, I misread it as 2 billion, it is as you said set as 200 million which is the default value for the parameter autovacuum_freeze_max_age.
I just wanted to confirm whether there would be any impact if I cancel or terminate the backend for the existing autovacuum :vacuum table_name (to prevent wraparound). I have initiated a normal vacuum manually but it is stuck on the table where the autovacuum is processing it.

Thanks,
Rijo Roy

Stack Overflow confirms my memories about killing autovacuum - pg_cancel_backend() should be fine.
https://stackoverflow.com/questions/18048842/danger-in-killing-autovacuum-vacuum-queries-to-prevent-wraparound

Steve.