"Huda Booley (h...@careerjunction.co.za)" <h...@careerjunction.co.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
-- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
