Re: Some pgbench results

From: Jim Nasby <jnasby(at)pervasive(dot)com>
To: Bernhard Weisshuhn <bkw(at)weisshuhn(dot)de>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Some pgbench results
Date: 2006-03-23 17:54:51
Message-ID: 5802FEE5-BC49-477C-B0C9-5DEDDDB47858@pervasive.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)pervasive(dot)com
Pervasive Software http://pervasive.com work: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Jim Nasby 2006-03-23 17:56:01 Re: Some pgbench results
Previous Message Jim Nasby 2006-03-23 17:51:39 Re: Enforcing serial uniqueness?