Re: Sun vs. Mac - gprof output

> It'd not be surprising for libreadline to suck a good deal of the
> runtime of psql ... but I don't believe the backend will call it at all.
> So, either this trace is erroneous, or you profiled the wrong process
> (client instead of backend), or there's something truly weird going on.

You're right, I got the client, here's the backend:

   %  cumulative    self              self    total
 time   seconds   seconds    calls  ms/call  ms/call name
 23.4     125.31   125.31                            internal_mcount [13]
 21.2     239.07   113.76 79296415     0.00     0.00  ExecMakeFunctionResult
<cycle 4> [14]
  7.8     280.68    41.61 98971658     0.00     0.00  AllocSetReset [23]
  6.8     317.13    36.45 193735603     0.00     0.00  ExecEvalVar [18]
  5.2     345.21    28.08 280731963     0.00     0.00  ExecEvalExpr     <cycle
4> [15]
  2.7     359.93    14.72 38140599     0.00     0.00  nocachegetattr [35]
  2.7     374.28    14.35   320207     0.04     0.04  _read [38]
  2.2     385.97    11.69 78969393     0.00     0.00  ExecQual  <cycle 4> [34]
  2.1     397.46    11.49 79296415     0.00     0.00  ExecEvalFuncArgs  <cycle
4> [42]
  1.4     404.71     7.25                            _mcount (6219)
  1.3     411.73     7.02 11293115     0.00     0.00  heapgettup [31]
  1.2     418.34     6.61 98975017     0.00     0.00  ExecClearTuple [43]
  1.0     423.93     5.59 98971592     0.00     0.00  ExecStoreTuple [33]
  0.9     428.87     4.94 197952332     0.00     0.00  MemoryContextSwitchTo
[53]
  0.9     433.53     4.66  7612547     0.00     0.00  heap_formtuple [39]
  0.8     437.96     4.43  7609318     0.00     0.01  ExecScanHashBucket
<cycle 4> [17]
  0.8     442.34     4.38        8   547.50   547.50  .rem [55]
  0.8     446.64     4.30 79296261     0.00     0.00  ExecEvalOper      <cycle
4> [56]


I'm not sure what to make of this.

Thanks,

-X


__________________________________________________
Do you Yahoo!?
Yahoo! Mail Plus - Powerful. Affordable. Sign up now.
http://mailplus.yahoo.com