Re: auto vacuum restart

From: Priancka Chatz <pc9926(at)gmail(dot)com>
To: Sridhar N Bamandlapally <sridhar(dot)bn1(at)gmail(dot)com>
Cc: pgsql-admin <pgsql-admin(at)postgresql(dot)org>
Subject: Re: auto vacuum restart
Date: 2021-05-04 13:05:25
Message-ID: CANnOdgYB4iu7xizi9b7Gt2J9vrbj-P6MQeCHPTVJsH71_vvtPA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hi Sridhar,

You can kill the autovacuum process like any other Postgres process but it
will restart most likely.
Hence, you may want to check why the autovacuum is running for so long. And
how much percentage has completed giving an idea of how much longer it will
run?

Regards,
Priyanka
.

On Tue, May 4, 2021 at 5:54 PM Sridhar N Bamandlapally <
sridhar(dot)bn1(at)gmail(dot)com> wrote:

> Hi,
>
> how do we stop and restart auto vacuum which is running long long time,
>
>
> Thanks
> Sridhar
>
>
>

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Jayson Hreczuck 2021-05-04 13:17:42 ETL tool for json and postgresql
Previous Message Sridhar N Bamandlapally 2021-05-04 12:23:40 auto vacuum restart