"Huda Booley (huda(at)careerjunction(dot)co(dot)za)"
<Huda(at)careerjunction(dot)co(dot)za> wrote:
> These get copied to the standby so its all there, just not being
> applied fast enough.
If the files are there and are not applying fast enough, it's
probably because on the source machine you can have multiple
connections submitting data modifications, keeping multiple CPUs and
spindles busy all at the same time. When playing back the WAL files
on the warm standby, you have one connection which has a harder time
keeping a lot of resources busy.
I think I have some recall of improvements to that in the 8.4
release, so an upgrade might help. Other than that, I think it's
mostly a matter of your hardware and OS. Make sure you have a RAID
controller with battery backed cache configured for write-back,
spread the database across as many spindles as you can, don't worry
so much about how *many* CPUs you have as how *fast* they are.
I've never actually had this problem, so take my advice on it with
a grain of salt.
-Kevin