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 configuration while HP StorageWorks SB40c SAN is 10x15k RAID1+0.
Running a hdparm -tT tests with different read-ahead, I see the following
differences on /dev/sda (local-storage) and /dev/sdc (SAN storage). I'm
shocked at the drop in buffered disk read performance 150MB/sec versus
80MB/sec and surprised at the SAN variability at 1MB/sec versus 10MB/sec,
local-storage and SAN storage respectively.
For those who, unlike me, have experience looking at SAN storage
performance, is the drop in buffered disk reads and large variability the
expected cost of centralized remote storage in SANs with fiber-channel
communication, SAN fail-over, etc.
If you have any ideas or insights and/or if you know of a better suited
forum for this question I'd sure appreciate the feedback.
Cheers,
Jan
