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

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

From: Mark Wong <markw(at)osdl(dot)org>
To: Rod Taylor <rbt(at)rbt(dot)ca>
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-02 01:58:07
Message-ID: 20031101175807.F2457@osdlab.pdx.osdl.net (view raw or flat)
Thread:
Lists: pgsql-hackers
I don't remember making a conscious decision between the number and integer
database type.  Is that a significant oversight on my part?


On Fri, Oct 31, 2003 at 08:04:34PM -0500, Rod Taylor wrote:
> 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: Mark WongDate: 2003-11-02 02:00:35
Subject: Re: OSDL DBT-2 w/ PostgreSQL 7.3.4 and 7.4beta5
Previous:From: Michael MaugerDate: 2003-11-02 01:36:56
Subject: Re: Proposal: psql force prompting on notty

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