Postgres Pro
Downloads
Home   >   mailing lists

Re: OSDL Database Test Suite 3 is available on PostgreSQL - Mailing list pgsql-performance

From Manfred Koizar
Subject Re: OSDL Database Test Suite 3 is available on PostgreSQL
Date
Msg-id ojksivc9quohitb6t3fabesb7ai5jn38vn@4ax.com
Whole thread Raw
In response to OSDL Database Test Suite 3 is available on PostgreSQL  (Jenny Zhang <jenny@osdl.org>)
Responses Re: OSDL Database Test Suite 3 is available on PostgreSQL  ("scott.marlowe" <scott.marlowe@ihs.com>)
Re: OSDL Database Test Suite 3 is available on PostgreSQL  ("scott.marlowe" <scott.marlowe@ihs.com>)
Re: OSDL Database Test Suite 3 is available on PostgreSQL  ("Shridhar Daithankar" <shridhar_daithankar@persistent.co.in>)
List pgsql-performance
Tree view 
On 01 Aug 2003 11:04:10 -0700, Jenny Zhang <jenny@osdl.org> wrote:
>A sample OSDL-DBT3 test result report can be found at:
>http://khack.osdl.org/stp/276912/
>
>Your comments are welcome,

| effective_cache_size           | 1000

With 4GB of memory this is definitely too low and *can* (note that I
don't say *must*) lead the planner to wrong decisions.

| shared_buffers                 | 15200

... looks reasonable.  Did you test with other values?

| sort_mem                       | 524288

This is a bit high, IMHO, but might be ok given that DBT3 is not run
with many concurrent sessions (right?).
http://khack.osdl.org/stp/276912/results/plot/vmstat_swap.png shows
some swapping activity towards the end of the run which could be
caused by a too high sort_mem setting.

Servus
 Manfred

pgsql-performance by date:

Previous
From: Ron Johnson
Date:
Subject: testing
Next
From: Manfred Koizar
Date:
Subject: Re: I can't wait too much: Total runtime 432478.44 msec