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.marlowe@gmail.com> wrote:
On Fri, Dec 23, 2011 at 8:32 AM, tuanhoanganh <
hatuan05@gmail.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 . . .
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.
