Mark Wong <[EMAIL PROTECTED]> 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 ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html