Re: Tips & Tricks for validating hardware/os

From: "Alexander Staubo" <alex(at)purefiction(dot)net>
To: "Stephane Bailliez" <sbailliez(at)gmail(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Tips & Tricks for validating hardware/os
Date: 2007-05-22 13:45:25
Message-ID: 88daf38c0705220645n3f37c975he2214f4d514b76b1@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On 5/22/07, Stephane Bailliez <sbailliez(at)gmail(dot)com> wrote:
> Out of curiosity, can anyone share his tips & tricks to validate a
> machine before labelling it as 'ready to use postgres - you probably
> won't trash my data today' ?
> I'm looking for a way to stress test components especially kernel/disk
> to have confidence > 0 that I can use postgres on top of it.
>
> Any secret trick is welcome (beside the memtest one :)

Compile the Linux kernel -- it's a pretty decent stress test.

You could run pgbench, which comes with PostgreSQL (as part of the
contrib package). Give a database size that's larger than the amount
of physical memory in the box.

Alexander.

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message PFC 2007-05-22 13:55:26 Re: Tips & Tricks for validating hardware/os
Previous Message Stephane Bailliez 2007-05-22 13:10:29 Tips & Tricks for validating hardware/os