Re: Vacuum Problems

Поиск
Список
Период
Сортировка
От Scott Marlowe
Тема Re: Vacuum Problems
Дата
Msg-id dcc563d10812080835o593d7a76pe564cfceb86f867c@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Vacuum Problems  ("Rafael Domiciano" <rafael.domiciano@gmail.com>)
Список pgsql-admin
On Mon, Dec 8, 2008 at 9:29 AM, Rafael Domiciano
<rafael.domiciano@gmail.com> wrote:
> 1 Drive Only. This server has no RAID.
> Do you think that the I/O is very high and I'm needing a RAID?!

Not necessarily.  Like I said, my laptop currently is about 25 to 30
times faster writing to disk than your server.  So, I think something
is wrong.  Try doing this, run vmstat 1, and while that's running, in
another window, do something like:

time dd if=/dev/zero of=/mnt/myslowdrive/testfile bs=1000000 count=500
time dd of=/dev/null if=/mnt/myslowdrive/testfile

and see what vmstat says while that's running, and how long it takes.
I'm guessing something is very wrong and you'll get really low
numbers.

В списке pgsql-admin по дате отправления:

Предыдущее
От: "Rafael Domiciano"
Дата:
Сообщение: Re: Vacuum Problems
Следующее
От: "Milen A. Radev"
Дата:
Сообщение: Re: Change in behavior of string concat operator