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
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 |