Re: Postgresql 9.0.6 Raid 5 or not please help.

From: Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>
To: tuanhoanganh <hatuan05(at)gmail(dot)com>
Cc: alexandre - aldeia digital <adaldeia(at)gmail(dot)com>, pgsql-performance(at)postgresql(dot)org
Subject: Re: Postgresql 9.0.6 Raid 5 or not please help.
Date: 2011-12-25 07:15:01
Message-ID: CAOR=d=0mtF4ZHe7z9uUqdGmDX10EwHGfq07OsqJ9y3jBP5p_tw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On Sat, Dec 24, 2011 at 8:13 PM, tuanhoanganh <hatuan05(at)gmail(dot)com> wrote:
> Thank for your information.
> My postgresql config fsync default
> #fsync = on # turns forced synchronization on or off
> My RAID is ServeRAID M5015 SAS/SATA controller, in MegaRaid Store Manager it
> show BBU Present = YES.
> Does it have battery backed caching RAID controller?
> Please help me, I am newbie of RAID card manager.

Yep you've got battery backed caching RAID. So regular pgbench tells
you how much faster RAID-1 is than RAID-5 at a read/write mixed load.
You can run it with a -s switch for a read only benchmark to get an
idea how much, if any, of a difference there is between the two.

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Pavel Stehule 2011-12-27 09:38:18 Re: How to clock the time spent for query parsing and planning?
Previous Message tuanhoanganh 2011-12-25 03:13:19 Re: Postgresql 9.0.6 Raid 5 or not please help.