Re: two disks - best way to use them? - Mailing list pgsql-performance

From David Lang
Subject Re: two disks - best way to use them?
Date
Msg-id Pine.LNX.4.62.0512051950560.2807@qnivq.ynat.uz
Whole thread Raw
In response to Re: two disks - best way to use them?  (Thomas Harold <tgh@tgharold.com>)
Responses Re: two disks - best way to use them?
List pgsql-performance
On Mon, 5 Dec 2005, Thomas Harold wrote:

> Yeah, I don't think I was clear about the config.  It's (4) disks setup as a
> pair of RAID1 sets.  My original config was pgsql on the first RAID set (data
> and WAL).  I'm now experimenting with putting the data/pg_xlog folder on the
> 2nd set of disks.
>
> Under the old setup (everything on the original RAID1 set, in a dedicated
> 32GB LVM volume), I was seeing 80-90% wait percentages in "top".  My
> understanding is that this is an indicator of an overloaded / bottlenecked
> disk system.  This was while doing massive inserts into a test table
> (millions of narrow rows).  I'm waiting to see what happens once I have
> data/pg_xlog on the 2nd disk set.

in that case you logicly have two disks, so see the post from Ron earlier
in this thread.

David Lang

pgsql-performance by date:

Previous
From: Jan Wieck
Date:
Subject: Re: 15,000 tables - next step
Next
From: Tom Lane
Date:
Subject: Re: BLCKSZ