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