vacuuming - Mailing list pgsql-performance

From Eugeny N Dzhurinsky
Subject vacuuming
Date
Msg-id 20060808073956.GA2087@office.redwerk.com
Whole thread Raw
Responses Re: vacuuming
List pgsql-performance
Hello

I have pg_autovacuum running with the arguments:

pg_autovacuum -D -s 120 -v 10000

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?

--
Eugene N Dzhurinsky

pgsql-performance by date:

Previous
From: "Alex Turner"
Date:
Subject: Re: Postgresql Performance on an HP DL385 and
Next
From: Ruben Rubio
Date:
Subject: shared_buffer optimization