Re: 8.3 / 8.2.6 restore comparison

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: 8.3 / 8.2.6 restore comparison
Дата
Msg-id 20603.1202436284@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: 8.3 / 8.2.6 restore comparison  ("Joshua D. Drake" <jd@commandprompt.com>)
Ответы Re: 8.3 / 8.2.6 restore comparison  ("Joshua D. Drake" <jd@commandprompt.com>)
Список pgsql-hackers
"Joshua D. Drake" <jd@commandprompt.com> writes:
> Following up with this... 22G in one hour, with xlogs on a different
> partition. Just looking at we are averaging 3-5% IOWait, further we are
> only writing ~ 2Megs a second.

It might be interesting to capture some strace output and get a sense of
what's actually being read and written.  It seems to me that the bad
I/O rate has to indicate that we're seeking all over the place.  We
should try to determine exactly what's being touched in what order.
        regards, tom lane


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

Предыдущее
От: Mark Wong
Дата:
Сообщение: Re: 8.3 / 8.2.6 restore comparison
Следующее
От: "Joshua D. Drake"
Дата:
Сообщение: Re: 8.3 / 8.2.6 restore comparison