Re: Slow restoration question

Поиск
Список
Период
Сортировка
От Scott Marlowe
Тема Re: Slow restoration question
Дата
Msg-id 1146691831.22037.50.camel@state.g2switchworks.com
обсуждение исходный текст
Ответ на Re: Slow restoration question  (Michael Stone <mstone+postgres@mathom.us>)
Ответы Re: Slow restoration question  (Michael Stone <mstone+postgres@mathom.us>)
Список pgsql-performance
On Wed, 2006-05-03 at 15:53, Michael Stone wrote:
> On Wed, May 03, 2006 at 02:40:15PM -0500, Scott Marlowe wrote:
> >Note that I'm referring to bonnie++ as was an earlier poster.  It
> >certainly seems capable of giving you a good idea of how your hardware
> >will behave under load.
>
> IME it give fairly useless results. YMMV. Definately the numbers posted
> before seem bogus. If you have some way to make those figures useful in
> your circumstance, great. Too often I see people taking bonnie numbers
> at face value and then being surprised that don't relate at all to
> real-world performance. If your experience differs, fine.

I think the real problem is that people use the older bonnie that can
only work with smaller datasets on a machine with all the memory
enabled.  This will, for certain, give meaningless numbers.

OTOH, having used bonnie++ on a machine artificially limited to 256 to
512 meg or ram or so, has given me some very useful numbers, especially
if you set the data set size to be several gigabytes.

Keep in mind, the numbers listed before likely WERE generated on a
machine with plenty of memory using the older bonnie, so those numbers
should be bogus.

If you've not tried bonnie++ on a limited memory machine, you really
should.  It's a quite useful tool for a simple first pass to figure out
which RAID and fs configurations should be tested more thoroughly.

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

Предыдущее
От: Michael Stone
Дата:
Сообщение: Re: Slow restoration question
Следующее
От: Michael Stone
Дата:
Сообщение: Re: Slow restoration question