Re: OSDL DBT-2 w/ PostgreSQL 7.3.4 and 7.4beta5

Excellent.

I just noticed that most of the numbers in the system are given the
numeric data type. Is there any particular reason you don't use integer
(test enforced?)?

On Fri, 2003-10-31 at 19:18, markw@osdl.org wrote:
> I thought someone might be interested in a data point I have comparing
> 7.3.4 and 7.4beta5 with results from our DBT-2 workload. Keep in mind I
> haven't done much tuning with either version.  The following links have
> references iostat, vmstat, sar, readprofile (linux kernel profile), and
> oprofile (postgresql profile) statistics.
>
> Results from 7.3.4:
>     http://developer.osdl.org/markw/dbt2-pgsql/184/
>     - metric 1354.58
>
> Results from 7.4beta5
>     http://developer.osdl.org/markw/dbt2-pgsql/188/
>     - metric 1446.01
>
> 7.4beta5 offers more throughput.  One significant difference I see is in
> the oprofile for the database.  For the additional 7% increase in the
> metric, there are about 32% less ticks in SearchCatCache.
>
> These are the only database parameters I've explicitly set for each one,
> any other differences will be differences in default values:
>     - shared_buffers = 40000
>     - tcpip_socket = true
>     - checkpoint_segments = 200
>     - checkpoint_timeout = 1800
>     - stats_start_collector = true
>     - stats_command_string = true
>     - stats_block_level = true
>     - stats_row_level = true
>     - stats_reset_on_server_start = true
>
> If anyone has any tuning recommendations for either 7.3 or 7.4, I'll be
> happy to try them.  Or if anyone wants to be able to poke around on the
> system, we can arrange that too.  Feel free to ask any questions.