Re: Autovacuum running forever

On 8/21/07, Sachchida Ojha <sojha@secure-elements.com> wrote:
>
>
> Is there any way to stop the autovacuum if it is running longer than 10 min
> or so?
>
> Is it good idea to kill autovacuum if it is running longer than expected?
>
> In my OLTP system, we are inserting, updating and deleting the data every
> second.
>
> Autovacuum started and never finished slowing down the whole system.

It's probably better to adjust the sleep parameters in postgresql.conf
and then pg_ctl reload

You can kill the autovacuum backend, but it will just start up again
when the sleep time has passed.