Re: Recovery/Restore and Roll Forward Question.

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.

--
Richard Huxton
Archonet Ltd