| From: | Brad Nicholson <bnichols(at)ca(dot)afilias(dot)info> |
|---|---|
| To: | Daniel van Ham Colchete <daniel(dot)colchete(at)gmail(dot)com> |
| Cc: | pgsql-performance(at)postgresql(dot)org |
| Subject: | Re: New to PostgreSQL, performance considerations |
| Date: | 2006-12-12 14:28:25 |
| Message-ID: | 1165933705.15903.77.camel@dba5.int.libertyrms.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Alexander Staubo | 2006-12-12 14:32:03 | Re: New to PostgreSQL, performance considerations |
| Previous Message | Michael Stone | 2006-12-12 12:56:35 | Re: New to PostgreSQL, performance considerations |