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(at)osdl(dot)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.