pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: Scott Marlowe <scott.marlowe@gmail.com>
To: Rafael Domiciano <rafael.domiciano@gmail.com>
Cc: Matthew T. O'Connor <matthew@zeut.net>
Cc: Rafael Martinez <r.m.guerrero@usit.uio.no>
Cc: pgsql-admin@postgresql.org <pgsql-admin@postgresql.org>
Subject: Re: Vacuum Problems
Date: Mon, 8 Dec 2008 09:35:08 -0700
Message-ID: <dcc563d10812080835o593d7a76pe564cfceb86f867c@mail.gmail.com> (raw)
In-Reply-To: <3a0028490812080829t1f485ec3g66626e8c4e2b610c@mail.gmail.com>
References: <3a0028490811260543x74d02719w775a457999cfc74@mail.gmail.com>
	<dcc563d10811260740m69f8969bt36be6ae675620dcb@mail.gmail.com>
	<3a0028490811260921l5d6aac06v54dca32aae672b97@mail.gmail.com>
	<492DA95D.3010303@zeut.net>
	<dcc563d10811261304g617b9806yf1208c4d5279ebee@mail.gmail.com>
	<3a0028490812080504x22618c6fxd7df8febaadb1632@mail.gmail.com>
	<dcc563d10812080735h42d94633v46449d9933dd22c@mail.gmail.com>
	<3a0028490812080811r1c8a4756i1a1a514911741def@mail.gmail.com>
	<dcc563d10812080817g5cc14e4bt1b573eb7edfb7e5e@mail.gmail.com>
	<3a0028490812080829t1f485ec3g66626e8c4e2b610c@mail.gmail.com>

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.



view thread (23+ messages)  latest in thread

Message-ID: <dcc563d10812080835o593d7a76pe564cfceb86f867c@mail.gmail.com>
Permalink:  ../dcc563d10812080835o593d7a76pe564cfceb86f867c@mail.gmail.com/
Also on:    postgresql.org/message-id/dcc563d10812080835o593d7a76pe564cfceb86f867c@mail.gmail.com

 · 

reply
Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-admin@postgresql.org
  Cc: scott.marlowe@gmail.com, rafael.domiciano@gmail.com, matthew@zeut.net, r.m.guerrero@usit.uio.no
  Subject: Re: Vacuum Problems
  In-Reply-To: <dcc563d10812080835o593d7a76pe564cfceb86f867c@mail.gmail.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox