| From: | Manfred Koizar <mkoi-pg(at)aon(dot)at> |
|---|---|
| To: | Jenny Zhang <jenny(at)osdl(dot)org> |
| Cc: | pgsql-performance(at)postgresql(dot)org, pgsql-general(at)postgresql(dot)org, osdldbt-general(at)lists(dot)sourceforge(dot)net |
| Subject: | Re: [PERFORM] OSDL Database Test Suite 3 is available on PostgreSQL |
| Date: | 2003-08-04 13:33:49 |
| Message-ID: | ojksivc9quohitb6t3fabesb7ai5jn38vn@4ax.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-performance |
On 01 Aug 2003 11:04:10 -0700, Jenny Zhang <jenny(at)osdl(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jan Poslusny | 2003-08-04 13:51:11 | Re: Monthly table partitioning for fast purges? |
| Previous Message | psql-mail | 2003-08-04 13:01:21 | Re: Monthly table partitioning for fast purges? |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Fernando Papa | 2003-08-04 14:01:41 | Re: I can't wait too much: Total runtime 432478.44 msec |
| Previous Message | Francisco J Reyes | 2003-08-03 14:27:11 | Re: Inheritance vs child tables (Was Domains) |
