Re: Slow restoration question - Mailing list pgsql-performance

From Jim C. Nasby
Subject Re: Slow restoration question
Date
Msg-id 20060503180821.GZ97354@pervasive.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, May 03, 2006 at 01:06:06PM -0400, Michael Stone wrote:
> On Wed, May 03, 2006 at 11:07:15AM -0500, Scott Marlowe wrote:
> >I have often used the mem=xxx arguments to lilo when needing to limit
> >the amount of memory for testing purposes.  Just google for limit memory
> >and your bootloader to find the options.
>
> Or, just don't worry about it. Even if you get bonnie to reflect real
> numbers, so what? In general the goal is to optimize application
> performance, not bonnie performance. A simple set of dd's is enough to
> give you a rough idea of disk performance, beyond that you really need
> to see how your disk is performing with your actual workload.

Well, in this case the question was about random write access, which dd
won't show you.
--
Jim C. Nasby, Sr. Engineering Consultant      jnasby@pervasive.com
Pervasive Software      http://pervasive.com    work: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf       cell: 512-569-9461

pgsql-performance by date:

Previous
From: Tom Lane
Date:
Subject: Re: Lot'sa joins - performance tip-up, please?
Next
From: Michael Stone
Date:
Subject: Re: Slow restoration question