On Tue, Aug 08, 2006 at 10:39:56AM +0300, Eugeny N Dzhurinsky wrote: > Hello > > I have pg_autovacuum running with the arguments: > > pg_autovacuum -D -s 120 -v 10000 It's been a while since I looked at the pg_autovac settings, but I know that it's threasholds were way, way to high. They were set to something like 2, when 0.2 is a better idea. > the database is postgresql 8.0.0 > > Sometimes load average on server raises to 20 and it is almost impossible to > login via SSH > > When I'm logging in finally, I see there is cpu usage: 6% and iowait 95% > > ps ax | grep post gives me > > postgres: postgres db [local] VACUUM > > Is there some solution to avoid such cases? Have you turned on vacuum_cost_delay? -- Jim C. Nasby, Sr. Engineering Consultant jnasby@xxxxxxxxxxxxx Pervasive Software http://pervasive.com work: 512-231-6117 vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461
