Postgres Pro
Downloads
Home   >   mailing lists

Re: Autovacuum running forever - Mailing list pgsql-performance

From Sachchida Ojha
Subject Re: Autovacuum running forever
Date
Msg-id E099DB9EF394534CBA0F62ED03CF3BBF05FDBEEC@EXVS01.IceMAIL.com
Whole thread Raw
In response to Re: Performance Solaris vs Linux  (Julius Stroffek <Julius.Stroffek@Sun.COM>)
Responses Re: Autovacuum running forever  ("Scott Marlowe" <scott.marlowe@gmail.com>)
List pgsql-performance
Tree view

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

 

 

pgsql-performance by date:

Previous
From: "Sachchida Ojha"
Date:
Subject: Autovacuum is running forever
Next
From: Michael Glaesemann
Date:
Subject: Re: Autovacuum is running forever