| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Mark Wong <markw(at)osdl(dot)org> |
| Cc: | Rod Taylor <rbt(at)rbt(dot)ca>, 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-20 19:47:45 |
| Message-ID: | 6274.1069357665@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
Mark Wong <markw(at)osdl(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Marc G. Fournier | 2003-11-20 20:00:44 | Re: 4 Clause license? |
| Previous Message | Joshua D. Drake | 2003-11-20 19:38:57 | Re: 4 Clause license? |