Re: Slow restoration question - Mailing list pgsql-performance

From Scott Marlowe
Subject Re: Slow restoration question
Date
Msg-id 1146691831.22037.50.camel@state.g2switchworks.com
Whole thread Raw
In response to Re: Slow restoration question  (Michael Stone <mstone+postgres@mathom.us>)
Responses Re: Slow restoration question
List 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 by date:

Previous
From: Michael Stone
Date:
Subject: Re: Slow restoration question
Next
From: Michael Stone
Date:
Subject: Re: Slow restoration question