Re: Postgresql 9.0.6 Raid 5 or not please help.

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.

Tuan Hoang Anh.

On Sat, Dec 24, 2011 at 1:06 AM, Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>wrote:

> On Fri, Dec 23, 2011 at 8:32 AM, tuanhoanganh <hatuan05(at)gmail(dot)com> wrote:
> > Thanks for all. I change to RAID 1 and here is new pg_bench result:
> >
> > pgbench -h 127.0.0.1 -p 5433 -U postgres -c 10 -T 1800 -s 10 pgbench
> > Scale option ignored, using pgbench_branches table count = 10
> > starting vacuum...end.
> > transaction type: TPC-B (sort of)
> > scaling factor: 10
> > query mode: simple
> > number of clients: 10
> > number of threads: 1
> > duration: 1800 s
> > number of transactions actually processed: 4373177
> > tps = 2429.396876 (including connections establishing)
> > tps = 2429.675016 (excluding connections establishing)
> > Press any key to continue . . .
>
> Note that those numbers are really only possible if your drives are
> lying about fsync or you have fsync turned off or you have a battery
> backed caching RAID controller. I.e. your database is likely not
> crash-proof.
>