Re: 8.4 open item: copy performance regression?

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: 8.4 open item: copy performance regression?
Дата
Msg-id 28355.1246048234@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: 8.4 open item: copy performance regression?  ("Kevin Grittner" <Kevin.Grittner@wicourts.gov>)
Ответы Re: 8.4 open item: copy performance regression?  ("Kevin Grittner" <Kevin.Grittner@wicourts.gov>)
Список pgsql-hackers
"Kevin Grittner" <Kevin.Grittner@wicourts.gov> writes:
> Regarding the fact that even with the xlog files pre-populated, the
> smaller set of xlog files is faster: I'm only guessing, but I suspect
> the battery backed RAID controller is what's defeating conventional
> wisdom here.  By writing to the same, relatively small, set of xlog
> files repeatedly, some of the actual disk writes probably evaporate in
> the BBU cache.

Yeah, sounds plausible.  How big is your BBU cache?
        regards, tom lane


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

Предыдущее
От: "Kevin Grittner"
Дата:
Сообщение: Re: 8.4 open item: copy performance regression?
Следующее
От: "Andrew Dunstan"
Дата:
Сообщение: Re: 8.4 open item: copy performance regression?