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