Re: [PERFORM] Configuration Recommendations

2012-05-19 Thread Jan Nielsen
Oops - couple of corrections and clarifications below... On Sat, May 19, 2012 at 9:47 AM, Jan Nielsen wrote: > After seeing less much performance during pg_dump and pg_restore > operations from a 10x15k SAN RAID1+1 XFS mount > 10x15k RAID1+0 on a SAN with XFS on /dev/sdc > (allocsize=256m,attr

Re: [PERFORM] Configuration Recommendations

2012-05-19 Thread Jan Nielsen
After seeing less much performance during pg_dump and pg_restore operations from a 10x15k SAN RAID1+1 XFS mount ( allocsize=256m,attr2,logbufs=8,logbsize=256k,noatime,nobarrier) than the local-storage 2x15k RAID1 EXT4 mount, I ran the following test of the effect of read-ahead (RA): for t in `seq