Re: pg_restore --multi-thread

Поиск
Список
Период
Сортировка
От Kevin Grittner
Тема Re: pg_restore --multi-thread
Дата
Msg-id 499E9A9E.EE98.0025.0@wicourts.gov
обсуждение исходный текст
Ответ на Re: pg_restore --multi-thread  (Andrew Dunstan <andrew@dunslane.net>)
Ответы Re: pg_restore --multi-thread
Список pgsql-hackers
>>> Andrew Dunstan <andrew@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


В списке pgsql-hackers по дате отправления:

Предыдущее
От: Kenneth Marshall
Дата:
Сообщение: Re: pg_restore --multi-thread
Следующее
От: "Joshua D. Drake"
Дата:
Сообщение: Re: pg_restore --multi-thread