Re: Some pgbench results - Mailing list pgsql-general

From Jim Nasby
Subject Re: Some pgbench results
Date
Msg-id 5802FEE5-BC49-477C-B0C9-5DEDDDB47858@pervasive.com
Whole thread Raw
In response to Re: Some pgbench results  (Bernhard Weisshuhn <bkw@weisshuhn.de>)
Responses Re: Some pgbench results
List pgsql-general
On Mar 23, 2006, at 11:32 AM, Bernhard Weisshuhn wrote:

> Just Someone wrote:
>
>> 2 10K SCSI disks in RAID1 for OS and WAL (with it's own partiton on
>> ext3),
>
> You'll want the WAL on its own spindle. IIRC a separate partition
> on a shared disc won't give you much benefit. The idea is to keep
> the disc's head from moving away for other tasks. Or so they say.

Actually, the OS partitions are normally quiet enough that it won't
make a huge difference, unless you're really hammering the database
all the time.
--
Jim C. Nasby, Sr. Engineering Consultant      jnasby@pervasive.com
Pervasive Software      http://pervasive.com    work: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf       cell: 512-569-9461



pgsql-general by date:

Previous
From: Jim Nasby
Date:
Subject: Re: Enforcing serial uniqueness?
Next
From: Jim Nasby
Date:
Subject: Re: Some pgbench results