Re: New to PostgreSQL, performance considerations - Mailing list pgsql-performance

From Brad Nicholson
Subject Re: New to PostgreSQL, performance considerations
Date
Msg-id 1165933705.15903.77.camel@dba5.int.libertyrms.com
Whole thread Raw
In response to Re: New to PostgreSQL, performance considerations  ("Daniel van Ham Colchete" <daniel.colchete@gmail.com>)
List pgsql-performance
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.


pgsql-performance by date:

Previous
From: Michael Stone
Date:
Subject: Re: New to PostgreSQL, performance considerations
Next
From: Alexander Staubo
Date:
Subject: Re: New to PostgreSQL, performance considerations