Re: Slow restoration question

From: "Jim C(dot) Nasby" <jnasby(at)pervasive(dot)com>
To: pgsql-performance(at)postgresql(dot)org
Subject: Re: Slow restoration question
Date: 2006-05-03 18:08:21
Message-ID: 20060503180821.GZ97354@pervasive.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)pervasive(dot)com
Pervasive Software http://pervasive.com work: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Michael Stone 2006-05-03 19:26:54 Re: Slow restoration question
Previous Message Tom Lane 2006-05-03 17:58:37 Re: Lot'sa joins - performance tip-up, please?