Autovacuum is running forever

From: "Sachchida Ojha" <sojha(at)secure-elements(dot)com>
To: <pgsql-performance(at)postgresql(dot)org>
Subject: Autovacuum is running forever
Date: 2007-08-21 21:26:45
Message-ID: E099DB9EF394534CBA0F62ED03CF3BBF05FDBEE2@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

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Sachchida Ojha 2007-08-21 21:30:09 Re: Autovacuum running forever
Previous Message Julius Stroffek 2007-08-21 15:49:13 Re: Performance Solaris vs Linux