From: | "Luke Lonergan" <LLonergan(at)greenplum(dot)com> |
---|---|
To: | "Jim Nasby" <decibel(at)decibel(dot)org>, "Pawel Gruszczynski" <pawel(dot)gruszczynski(at)inea(dot)com(dot)pl> |
Cc: | pgsql-performance(at)postgresql(dot)org |
Subject: | Re: What`s wrong with JFS configuration? |
Date: | 2007-04-26 08:17:39 |
Message-ID: | C3E62232E3BCF24CBA20D72BFDCB6BF802AF2C31@MI8NYCMAIL08.Mi8.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-performance |
The outer track / inner track performance ratio is more like 40 percent. Recent example is 78MB/s outer and 44MB/s inner for the new Seagate 750MB drive (see http://www.storagereview.com for benchmark results)
- Luke
Msg is shrt cuz m on ma treo
-----Original Message-----
From: Jim Nasby [mailto:decibel(at)decibel(dot)org]
Sent: Thursday, April 26, 2007 03:53 AM Eastern Standard Time
To: Pawel Gruszczynski
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: [PERFORM] What`s wrong with JFS configuration?
On Apr 25, 2007, at 8:51 AM, Pawel Gruszczynski wrote:
> where u6 stores Fedora Core 6 operating system, and u0 stores 3
> partitions with ext2, ext3 and jfs filesystem.
Keep in mind that drives have a faster data transfer rate at the
outer-edge than they do at the inner edge, so if you've got all 3
filesystems sitting on that array at the same time it's not a fair
test. I heard numbers on the impact of this a *long* time ago and I
think it was in the 10% range, but I could be remembering wrong.
You'll need to drop each filesystem and create the next one to get a
fair comparison.
--
Jim Nasby jim(at)nasby(dot)net
EnterpriseDB http://enterprisedb.com 512.569.9461 (cell)
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
From | Date | Subject | |
---|---|---|---|
Next Message | Gregory Stark | 2007-04-26 08:35:24 | Re: seeking advise on char vs text or varchar in search table |
Previous Message | Greg Smith | 2007-04-26 04:04:53 | Re: What`s wrong with JFS configuration? |