On Fri, Dec 23, 2011 at 8:32 AM, tuanhoanganh <hatuan05@xxxxxxxxx> 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. -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
