Re: [PERFORM] Postgresql 9.0.6 Raid 5 or not please help.

2011-12-23 Thread Mario Weilguni
Am 23.12.2011 08:05, schrieb Scott Marlowe: On Thu, Dec 22, 2011 at 11:18 PM, tuanhoanganh wrote: Thanks for your answer. But how performance between raid5 and one disk. One disk will usually win, 2 disks (in a mirror) will definitely win. RAID-5 has the highest overhead and the poorest perfor

Re: [PERFORM] Postgresql 9.0.6 Raid 5 or not please help.

2011-12-23 Thread alexandre - aldeia digital
I'm not so confident that a RAID-1 will win over a single disk. When it comes to writes, the latency should be ~50 higher (if both disk must sync), since the spindles are not running synchronously. This applies to softraid, not something like a battery-backend raid controller of course. Or am I w

Re: [PERFORM] Postgresql 9.0.6 Raid 5 or not please help.

2011-12-23 Thread Scott Marlowe
On Fri, Dec 23, 2011 at 5:15 AM, alexandre - aldeia digital wrote: >> I'm not so confident that a RAID-1 will win over a single disk. When it >> comes to writes, the latency should be ~50 higher (if both disk must >> sync), since the spindles are not running synchronously. This applies to >> softr

Re: [PERFORM] Postgresql 9.0.6 Raid 5 or not please help.

2011-12-23 Thread tuanhoanganh
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 nu

Re: [PERFORM] Postgresql 9.0.6 Raid 5 or not please help.

2011-12-23 Thread Scott Marlowe
On Fri, Dec 23, 2011 at 8:32 AM, tuanhoanganh 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. > transacti