Re: [PERFORM] local-storage versus SAN sequential read performance comparison

2012-05-21 Thread Shaun Thomas
On 05/21/2012 10:41 AM, Scott Marlowe wrote: How fast is the link to your SAN? If it's Gigabit, then 80MB/s would be pretty reasonable. Wow, I didn't even think of that. I was looking up specs on the SAN. :) Those stats are pretty horrible for sequential reads. The SAN should improve random

Re: [PERFORM] local-storage versus SAN sequential read performance comparison

2012-05-21 Thread Scott Marlowe
How fast is the link to your SAN? If it's Gigabit, then 80MB/s would be pretty reasonable. Also SANs are normally known for very good random access performance and not necessarily for fast sequential performance. On Mon, May 21, 2012 at 8:17 AM, Jan Nielsen wrote: > This is outside of PG perfor

[PERFORM] local-storage versus SAN sequential read performance comparison

2012-05-21 Thread Jan Nielsen
This is outside of PG performance proper, but while testing pg_dump and pg_restore performance on local-storage versus SAN storage I noticed a big performance drops on in the SAN configuration. I'm told that both local storage and SAN storage are 15k drives with local-storage running dual RAID1 con