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

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