Re: PITR and warm standby setup questions

["Mason Hale" <masonhale@xxxxxxxxx>]

your i/o must be really random to be seeing numbers that lousy (10
seconds to replay a file is 1.6 megabytes/sec), or there is some other
unexplained problem with your server.  is your raid controller
properly caching wites?  have you benchmarked the volume with bonnie++
or similar tool (pay close attention to seeks).

Here's the bonnie++ output (two runs):

Version  1.03       ------Sequential Output------ --Sequential Input- --Random-
                    -Per Chr- --Block-- -Rewrite- -Per Chr- --Block-- --Seeks--
Machine        Size K/sec %CP K/sec %CP K/sec %CP K/sec %CP K/sec %CP  /sec %CP
dev-db-2        32G 43174  99 87421  24 45614  12 48302  97 164574  23 205.3   0
                    ------Sequential Create------ --------Random Create--------
                    -Create-- --Read--- -Delete-- -Create-- --Read--- -Delete--
              files  /sec %CP  /sec %CP  /sec %CP  /sec %CP  /sec %CP  /sec %CP
                 16 +++++ +++ +++++ +++ +++++ +++ +++++ +++ +++++ +++ +++++ +++

Having never used bonnie++ before, I don't have a baseline to compare this against, but that looks like 87MB/s writes and 164MB/s reads to me. Am I reading this correctly? It looks pretty good to me.

Here is some output from iostat

Device:            tps   Blk_read/s   Blk_wrtn/s   Blk_read   Blk_wrtn
sda               0.00         0.00         0.00          0          0
sdb               1.00         0.00        55.72          0        112
sdc               1.00         0.00        63.68           0        128
sdd             101.49      1699.50         0.00       3416          0

avg-cpu:  %user   %nice %system %iowait  %steal   %idle
           0.06    0.00    0.06   12.37    0.00   87.51

Device:            tps   Blk_read/s   Blk_wrtn/s   Blk_read   Blk_wrtn
sda               2.50         0.00        24.00          0         48
sdb               0.00         0.00         0.00          0          0
sdc              42.50         0.00      8288.00          0      16576
sdd             101.50      1688.00         0.00        3376          0

avg-cpu:  %user   %nice %system %iowait  %steal   %idle
           0.12    0.00    0.06   12.35    0.00   87.46

Device:            tps   Blk_read/s   Blk_wrtn/s   Blk_read   Blk_wrtn
sda               0.00         0.00         0.00          0          0
sdb               0.00         0.00         0.00           0          0
sdc               0.00         0.00         0.00          0          0
sdd             112.44      1787.06         0.00       3592          0

avg-cpu:  %user   %nice %system %iowait  %steal   %idle
           0.12    0.00    0.06   12.36    0.00   87.45

Device:            tps   Blk_read/s   Blk_wrtn/s   Blk_read   Blk_wrtn
sda               0.00         0.00         0.00          0          0
sdb               4.50         0.00        48.00          0         96
sdc               0.50         0.00         4.00          0          8
sdd              97.50      1752.00         0.00        3504          0

In the above: sdb holds the pg_xlog directory, sdc holds the wal archive, and sdd is the 4 disk RAID 1+0 where the pgdata directory is stored. All these disks are ext3 with noatime,data="" mount options. The RAID controller is an Adaptec 3805 with 128MB battery backed cache (only option offered by our hosting provider for this server class).

Does any of this shed any light on how to boost my restore performance?

thanks,
Mason