Horton

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

Tom Lane <tgl@sss.pgh.pa.us>

View thread View on postgr.es
From: Tom Lane <tgl@sss.pgh.pa.us>
To: Mark Wong <markw@osdl.org>
Cc: Rod Taylor <rbt@rbt.ca>, PostgreSQL Development <pgsql-hackers@postgresql.org>, OSDL - DB General <osdldbt-general@lists.sourceforge.net>
Date: 2003-11-20T19:47:45Z
Lists: pgsql-hackers 
Mark Wong <markw@osdl.org> writes:
> I've changed all the numerics to integers and reals, where it was appropriate
> to maintain the precision specificed in the TPC-C spec.
> ...
> Looks like I see about an 8% improvement in the metric with this instance.  A
> definite decrease in user time in the processor utilization chart, which I
> presume is attributed to the 70% decrease in ticks to SearchCatCache in the
> database as reported by oprofile.  Can anyone explain that one?

That's odd; I don't see why NUMERIC would be incurring extra
SearchCatCache calls.  Does your profile provide info about where the
SearchCatCache calls are coming from?

			regards, tom lane