pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: Greg Smith <gsmith@gregsmith.com>
To: pgsql-performance@postgresql.org
Subject: Re: Tips & Tricks for validating hardware/os
Date: Wed, 23 May 2007 00:11:35 -0400 (EDT)
Message-ID: <Pine.GSO.4.64.0705222350580.6041@westnet.com> (raw)
In-Reply-To: <4652EBC5.3090802@gmail.com>
References: <4652EBC5.3090802@gmail.com>

On Tue, 22 May 2007, Stephane Bailliez 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' ?

Write a little script that runs pgbench in a loop forever.  Set your 
shared_buffer cache to use at least 50% of the memory in the machine, and 
adjust the database size and concurrent clients so it's generating a 
substantial amount of disk I/O and using a fair amount of the CPU.

Install the script so that it executes on system startup, like adding it 
to rc.local Put the machine close to your desk.  Every time you walk by 
it, kill the power and then start it back up.  This will give you a mix of 
long overnight runs with no interruption to stress the overall system, 
with a nice dose of recovery trauma.  Skim the Postgres and OS log files 
every day.  Do that for a week, if it's still running your data should be 
safe under real conditions.

--
* Greg Smith gsmith@gregsmith.com http://www.gregsmith.com Baltimore, MD



view thread (6+ messages)  latest in thread

Message-ID: <Pine.GSO.4.64.0705222350580.6041@westnet.com>
Permalink:  ../Pine.GSO.4.64.0705222350580.6041@westnet.com/
Also on:    postgresql.org/message-id/Pine.GSO.4.64.0705222350580.6041@westnet.com

 · 

reply
Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-performance@postgresql.org
  Cc: gsmith@gregsmith.com
  Subject: Re: Tips & Tricks for validating hardware/os
  In-Reply-To: <Pine.GSO.4.64.0705222350580.6041@westnet.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox