| From: | "Merlin Moncure" <mmoncure(at)gmail(dot)com> |
|---|---|
| To: | "Mason Hale" <masonhale(at)gmail(dot)com> |
| Cc: | pgsql-general <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: PITR and warm standby setup questions |
| Date: | 2007-11-13 00:30:12 |
| Message-ID: | b42b73150711121630x53f0d254u776c0485edff225b@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Nov 12, 2007 6:59 PM, Mason Hale <masonhale(at)gmail(dot)com> wrote:
> I am setting up a warm standby configuration as described here:
>
> http://www.postgresql.org/docs/8.2/static/warm-standby.html
>
> Using PostgreSql 8.2.5
>
> My production server is archiving 16MB wal segment files at a rate of 1
> every 5 to 10 seconds
> My standby server is processing the wal segment files at a rate of 1 every
> 10 to 40 seconds
> At this rate the standby will never keep up with the production server.
>
> The production server has a 10 disk RAID 1+0 configuration and 32GB RAM
> The standby server has a 4 disk RAID 1+0 configuration and 16GB RAM, with an
> extra disk to hold the wal archive files (separate from the RAID)
> otherwise they are identically configured
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).
merlin
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Decibel! | 2007-11-13 01:05:24 | Re: Updated .vim file |
| Previous Message | Mason Hale | 2007-11-12 23:59:17 | PITR and warm standby setup questions |