Re: Vacuum Problems - Mailing list pgsql-admin

From Scott Marlowe
Subject Re: Vacuum Problems
Date
Msg-id dcc563d10812080835o593d7a76pe564cfceb86f867c@mail.gmail.com
Whole thread Raw
In response to Re: Vacuum Problems  ("Rafael Domiciano" <rafael.domiciano@gmail.com>)
List 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 by date:

Previous
From: "Rafael Domiciano"
Date:
Subject: Re: Vacuum Problems
Next
From: "Milen A. Radev"
Date:
Subject: Re: Change in behavior of string concat operator