Re: file system and raid performance

From: "Mark Wong" <markwkm(at)gmail(dot)com>
To: "Bruce Momjian" <bruce(at)momjian(dot)us>
Cc: david(at)lang(dot)hm, pgsql-performance(at)postgresql(dot)org, "Gabrielle Roth" <gorthx(at)gmail(dot)com>
Subject: Re: file system and raid performance
Date: 2008-08-18 15:33:44
Message-ID: 70c01d1d0808180833m4a10b39ak9e9c367554a44a67@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On Fri, Aug 15, 2008 at 12:22 PM, Bruce Momjian <bruce(at)momjian(dot)us> wrote:
> Mark Wong wrote:
>> On Mon, Aug 4, 2008 at 10:04 PM, <david(at)lang(dot)hm> wrote:
>> > On Mon, 4 Aug 2008, Mark Wong wrote:
>> >
>> >> Hi all,
>> >>
>> >> We've thrown together some results from simple i/o tests on Linux
>> >> comparing various file systems, hardware and software raid with a
>> >> little bit of volume management:
>> >>
>> >> http://wiki.postgresql.org/wiki/HP_ProLiant_DL380_G5_Tuning_Guide
>
> Mark, very useful analysis. I am curious why you didn't test
> 'data=writeback' on ext3; 'data=writeback' is the recommended mount
> method for that file system, though I see that is not mentioned in our
> official documentation.

I have one set of results with ext3 data=writeback and it appears that
some of the write tests have less throughput than data=ordered. For
anyone who wants to look at the results details:

http://wiki.postgresql.org/wiki/HP_ProLiant_DL380_G5_Tuning_Guide

it's under the "Aggregate Bandwidth (MB/s) - RAID 5 (256KB stripe) -
No partition table" table.

Regards,
Mark

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Moritz Onken 2008-08-18 15:49:38 Re: Slow query with a lot of data
Previous Message Tom Lane 2008-08-18 15:20:00 Re: Cross Join Problem