On 8/21/07, Sachchida Ojha <sojha@xxxxxxxxxxxxxxxxxxx> 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. ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster
