From: | Ogden <lists(at)darkstatic(dot)com> |
---|---|
To: | Andy Colson <andy(at)squeakycode(dot)net> |
Cc: | pgsql-performance(at)postgresql(dot)org |
Subject: | Re: Raid 5 vs Raid 10 Benchmarks Using bonnie++ |
Date: | 2011-08-17 18:55:17 |
Message-ID: | 0B8DE623-CF5C-4125-AA9E-8695A29CE0EC@darkstatic.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-performance |
On Aug 17, 2011, at 1:48 PM, Andy Colson wrote:
> On 8/17/2011 1:35 PM, ktm(at)rice(dot)edu wrote:
>> On Wed, Aug 17, 2011 at 01:32:41PM -0500, Ogden wrote:
>>>
>>> On Aug 17, 2011, at 1:31 PM, ktm(at)rice(dot)edu wrote:
>>>
>>>> On Wed, Aug 17, 2011 at 01:26:56PM -0500, Ogden wrote:
>>>>> I am using bonnie++ to benchmark our current Postgres system (on RAID 5) with the new one we have, which I have configured with RAID 10. The drives are the same (SAS 15K). I tried the new system with ext3 and then XFS but the results seem really outrageous as compared to the current system, or am I reading things wrong?
>>>>>
>>>>> The benchmark results are here:
>>>>>
>>>>> http://malekkoheavyindustry.com/benchmark.html
>>>>>
>>>>>
>>>>> Thank you
>>>>>
>>>>> Ogden
>>>>
>>>> That looks pretty normal to me.
>>>>
>>>> Ken
>>>
>>> But such a jump from the current db01 system to this? Over 20 times difference from the current system to the new one with XFS. Is that much of a jump normal?
>>>
>>> Ogden
>>
>> Yes, RAID5 is bad for in many ways. XFS is much better than EXT3. You would get similar
>> results with EXT4 as well, I suspect, although you did not test that.
>>
>> Regards,
>> Ken
>>
>
> A while back I tested ext3 and xfs myself and found xfs performs better for PG. However, I also have a photos site with 100K files (split into a small subset of directories), and xfs sucks bad on it.
>
> So my db is on xfs, and my photos are on ext4.
What about the OS itself? I put the Debian linux sysem also on XFS but haven't played around with it too much. Is it better to put the OS itself on ext4 and the /var/lib/pgsql partition on XFS?
Thanks
Ogden
From | Date | Subject | |
---|---|---|---|
Next Message | Ogden | 2011-08-17 18:56:17 | Re: Raid 5 vs Raid 10 Benchmarks Using bonnie++ |
Previous Message | hyelluas | 2011-08-17 18:51:59 | Re: How to see memory usage using explain analyze ? |