Richard Huxton wrote: > Bruce McAlister wrote: >> Thats exactly what I think. There is something strange going on. At the >> moment I think it is the disk I am writing the data to that is slow, >> possibly due to the fact that it is mounted up as "forcedirectio", so as >> not to interfere with the file system cache which we want to have mainly >> pg datafiles in, and the RAID controller has this particular logical >> driver configured as write-through, so there is no buffering in-between. >> The cpu's and network are not the problem here (2 x Dual Core Opterons >> and Quad Gigabit Ethernet, total cpu usage is around 10%, NIC's are >> pushing around 3Mbit/s over each). >> >> It's not all that big to be honest, the total database size is around >> 11GB and I'm currently recking my head to find out how to improve the >> backup times, and not adversely affect our running instance. > > 11GB in 2 hours? Let's see, that's ~1.5MB/sec. Something is horribly > wrong there - you could do better than that with a USB 1 drive. > LOL, now that you put it that way, I'll be sure to put some time in to get to the bottom of the issue. Jeez, not even USB 2 speeds, maybe i should hook my thumb drive in the back of the box and send backups there to prove a point :)
