Re: Autovacuum running forever

From: "Sachchida Ojha" <sojha(at)secure-elements(dot)com>
To: <pgsql-performance(at)postgresql(dot)org>
Subject: Re: Autovacuum running forever
Date: 2007-08-21 21:30:09
Message-ID: E099DB9EF394534CBA0F62ED03CF3BBF05FDBEEC@EXVS01.IceMAIL.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

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.

Any help?

Thanks

Regards

sachi

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Michael Glaesemann 2007-08-21 21:35:57 Re: Autovacuum is running forever
Previous Message Sachchida Ojha 2007-08-21 21:26:45 Autovacuum is running forever