Received: from localhost (maia-4.hub.org [200.46.204.183])
	by postgresql.org (Postfix) with ESMTP id 10AFC9F946C
	for <pgsql-performance-postgresql.org@postgresql.org>;
	Tue, 12 Dec 2006 10:28:37 -0400 (AST)
Received: from postgresql.org ([200.46.204.71])
	by localhost (mx1.hub.org [200.46.204.183]) (amavisd-new, port 10024)
	with ESMTP id 35679-05 for
	<pgsql-performance-postgresql.org@postgresql.org>;
	Tue, 12 Dec 2006 10:28:28 -0400 (AST)
X-Greylist: from auto-whitelisted by SQLgrey-1.7.4
Received: from mail.libertyrms.com (vgateway.libertyrms.info [207.219.45.62])
	by postgresql.org (Postfix) with ESMTP id B0D539F9F08
	for <pgsql-performance@postgresql.org>;
	Tue, 12 Dec 2006 10:28:28 -0400 (AST)
Received: from dba5.int.libertyrms.com ([10.1.3.44])
	by mail.libertyrms.com with esmtp (Exim 4.22)
	id 1Gu8cM-0003UK-EZ; Tue, 12 Dec 2006 09:28:26 -0500
Subject: Re: New to PostgreSQL, performance considerations
From: Brad Nicholson <bnichols@ca.afilias.info>
To: Daniel van Ham Colchete <daniel.colchete@gmail.com>
Cc: pgsql-performance@postgresql.org
In-Reply-To: <8a0c7af10612111422x6bdcc0c2p7cbfeb5a7b0e0374@mail.gmail.com>
References: <430d92a20612101336r3de8862coe618277fccb4006a@mail.gmail.com>
	<87u002mv49.fsf@wolfe.cbbrowne.com>
	<8a0c7af10612110531sbb019ck259fb16d131fdb50@mail.gmail.com>
	<60psaq5t94.fsf@dba2.int.libertyrms.com>
	<E1GtolA-0008Fk-4R@elasmtp-banded.atl.sa.earthlink.net>
	<20061211173105.GH16692@mathom.us>
	<E1Gtplp-0004Ka-GM@elasmtp-junco.atl.sa.earthlink.net>
	<20061211184726.GI16692@mathom.us>
	<E1GtrB8-0005rw-Iu@elasmtp-kukur.atl.sa.earthlink.net>
	<457DA782.3060506@modgraph-usa.com>
	<8a0c7af10612111422x6bdcc0c2p7cbfeb5a7b0e0374@mail.gmail.com>
Content-Type: text/plain
Date: Tue, 12 Dec 2006 09:28:25 -0500
Message-Id: <1165933705.15903.77.camel@dba5.int.libertyrms.com>
Mime-Version: 1.0
X-Mailer: Evolution 2.6.3 (2.6.3-1.fc5.5) 
Content-Transfer-Encoding: 7bit
X-SA-Exim-Mail-From: bnichols@ca.afilias.info
X-SA-Exim-Scanned: No; SAEximRunCond expanded to false
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Archive-Number: 200612/290
X-Sequence-Number: 22346

On Mon, 2006-12-11 at 20:22 -0200, Daniel van Ham Colchete wrote:
> 
> I'm thinking about writing a script to make all the tests (more than 3
> times each), get the data and plot some graphs.
> 
> I don't have the time right now to do it, maybe next week I'll have.

Check out the OSDL test suite stuff.  It runs the test and handles all
the reporting for you (including graphs).
http://www.osdl.org/lab_activities/kernel_testing/osdl_database_test_suite/

> I invite everyone to comment/sugest on the procedure or the results.

I'd recommend running each test for quite a bit longer.  Get your
buffers dirty and exercised, and see what things look like then.

Also, if you have the disk, offload your wal files to a separate disk.
-- 
Brad Nicholson  416-673-4106
Database Administrator, Afilias Canada Corp.