Re: Postgresql 9.0.6 Raid 5 or not please help.

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.