vacuuming

From: Eugeny N Dzhurinsky <bofh(at)redwerk(dot)com>
To: pgsql-performance(at)postgresql(dot)org
Subject: vacuuming
Date: 2006-08-08 07:39:56
Message-ID: 20060808073956.GA2087@office.redwerk.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message kumarselvan 2006-08-08 08:42:02 BUG #2567: High IOWAIT
Previous Message Alex Turner 2006-08-08 06:40:39 Re: Postgresql Performance on an HP DL385 and