Skip site navigation (1) Skip section navigation (2)

Re: Vacuum Problems

From: "Scott Marlowe" <scott(dot)marlowe(at)gmail(dot)com>
To: "Rafael Domiciano" <rafael(dot)domiciano(at)gmail(dot)com>
Cc: "Matthew T(dot) O'Connor" <matthew(at)zeut(dot)net>, "Rafael Martinez" <r(dot)m(dot)guerrero(at)usit(dot)uio(dot)no>, "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>
Subject: Re: Vacuum Problems
Date: 2008-12-08 16:35:08
Message-ID: dcc563d10812080835o593d7a76pe564cfceb86f867c@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-admin
On Mon, Dec 8, 2008 at 9:29 AM, Rafael Domiciano
<rafael(dot)domiciano(at)gmail(dot)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.

In response to

Responses

pgsql-admin by date

Next:From: Milen A. RadevDate: 2008-12-08 16:57:00
Subject: Re: Change in behavior of string concat operator
Previous:From: Rafael DomicianoDate: 2008-12-08 16:29:02
Subject: Re: Vacuum Problems

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group