Re: Recovery/Restore and Roll Forward Question.

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 :)