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

help / color / mirror / Atom feed
From: Brad Nicholson <bnichols@ca.afilias.info>
To: Daniel van Ham Colchete <daniel.colchete@gmail.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: New to PostgreSQL, performance considerations
Date: Tue, 12 Dec 2006 09:28:25 -0500
Message-ID: <1165933705.15903.77.camel@dba5.int.libertyrms.com> (raw)
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>

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.




view thread (124+ messages)  latest in thread

Message-ID: <1165933705.15903.77.camel@dba5.int.libertyrms.com>
Permalink:  ../1165933705.15903.77.camel@dba5.int.libertyrms.com/
Also on:    postgresql.org/message-id/1165933705.15903.77.camel@dba5.int.libertyrms.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: bnichols@ca.afilias.info, daniel.colchete@gmail.com
  Subject: Re: New to PostgreSQL, performance considerations
  In-Reply-To: <1165933705.15903.77.camel@dba5.int.libertyrms.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