|
From: Rijo Roy [mailto:rjo_roy@xxxxxxxxx]
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. Steve. |
