>>> Andrew Dunstan <and...@dunslane.net> wrote: > Joshua D. Drake wrote: >> the fastest restore time for >> 220G was performed with 24 threads with an 8 core box. >> It is important to point out that this was a machine with 50 spindles. >> Which is where your bottleneck is going to be immediately after solving >> the CPU bound nature of the problem. > But you are right that there isn't a simple formula. Perhaps the greater of the number of CPUs or effective spindles? (24 sounds suspiciously close to effective spindles on a 50 spindle box with RAID 10.) -Kevin
-- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers