Postgres Pro
Downloads
Home   >   mailing lists

autovac hitting too many tables at once - Mailing list pgsql-admin

From Greg Williamson
Subject autovac hitting too many tables at once
Date
Msg-id 1340391499.61601.YahooMailNeo@web46101.mail.sp1.yahoo.com
Whole thread Raw
Responses Re: autovac hitting too many tables at once  ("Kevin Grittner" <Kevin.Grittner@wicourts.gov>)
List pgsql-admin
Tree view 
Hi,

I've got an 8.4.11 system that I am relatively new to and I am seeing multiple autovac processes kick off on several of
thelargest tables at once and it is causing pain. 

Are there any suggestions to

  a) quickly relieve the immediate pain

and

  b) prevent such issues in the future (other than going to manual vacuuming on a schedule).

Thanks,

Greg Williamson

pgsql-admin by date:

Previous
From: Greg Smith
Date:
Subject: Re: about shared_buffer and kernel.shmmax
Next
From: "Kevin Grittner"
Date:
Subject: Re: autovac hitting too many tables at once