On Wed, 6 Feb 2008, Joshua D. Drake wrote:
8.2.6 after 2 hours has restored 41GB.
I've been doing a long bulk import job recently (COPY) on a box with more spindles than yours (but with a dumb controller) and I too am stuck at that speed; I calculate a consistant 19.6GB/hour. The actual disk I/O is very low as that works out to only 5.7MB/s of progress. Mine was bottlenecked by capacity of a single CPU (4X Opteron system). I think this is one of those barriers it's hard to crack without a caching controller, for reasons I haven't figured out completely yet.
I am thinking the way we are going to need to do this is to have an extended outage and write a custom script to do a concurrent dump and load.
If you look at the -performance list this week I've been yelping about this issue and trying to figure out how to setup a useful multi-CPU loader for cases like these.
-- * Greg Smith [EMAIL PROTECTED] http://www.gregsmith.com Baltimore, MD ---------------------------(end of broadcast)--------------------------- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
