Re: Tips & Tricks for validating hardware/os

On 5/22/07, Stephane Bailliez <sbailliez@gmail.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.