Skip site navigation (1) Skip section navigation (2)

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

From: Rod Taylor <rbt(at)rbt(dot)ca>
To: markw(at)osdl(dot)org
Cc: PostgreSQL Development <pgsql-hackers(at)postgresql(dot)org>,OSDL - DB General <osdldbt-general(at)lists(dot)sourceforge(dot)net>
Subject: Re: OSDL DBT-2 w/ PostgreSQL 7.3.4 and 7.4beta5
Date: 2003-11-01 01:04:34
Message-ID: 1067648641.18476.23.camel@jester (view raw or flat)
Thread:
Lists: pgsql-hackers
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.

In response to

Responses

pgsql-hackers by date

Next:From: Peter EisentrautDate: 2003-11-01 03:06:00
Subject: Problems with whitespace-ignoring diff options
Previous:From: Cuong Bui (lokishop.nl)Date: 2003-11-01 01:02:35
Subject: Re: Vacuum thoughts

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group