Re: not exactly a bug report, but surprising behaviour

Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> writes:

> Greg Stark <gsstark(at)mit(dot)edu> writes:
>
> Two things: one, backends dump gmon.out into $PGDATA/base/yourdb/,
> whereas the postmaster dumps into wherever you started it (it never does
> chdir IIRC). Two, if you're on Linux you must compile postmaster.c with
> -DLINUX_PROFILE, or you won't get any profiling timer interrupts in
> child processes.
>
> Your sample looks like the second problem...

Actually I had both problems, I didn't realize the backends did a chdir.

I cancelled it partway through.

% cumulative self self total
time seconds seconds calls s/call s/call name
16.59 97.88 97.88 69608411 0.00 0.00 ExecMakeFunctionResult
7.08 139.65 41.77 79472258 0.00 0.00 comparetup_heap
4.50 166.17 26.52 192211935 0.00 0.00 ExecEvalExpr
3.94 189.41 23.24 155884536 0.00 0.00 AllocSetAlloc
2.57 204.59 15.18 69608411 0.00 0.00 ExecEvalFuncArgs
2.57 219.76 15.17 17360796 0.00 0.00 heap_formtuple
2.25 233.03 13.27 248222443 0.00 0.00 AllocSetFreeIndex
2.22 246.11 13.08 17360724 0.00 0.00 ExecTargetList
2.17 258.92 12.81 45871623 0.00 0.00 ExecEvalParam
1.99 270.65 11.73 17360796 0.00 0.00 DataFill
1.82 281.37 10.72 23020517 0.00 0.00 AllocSetReset
1.57 290.62 9.25 29962044 0.00 0.00 ExecEvalVar
1.29 298.20 7.58 17360796 0.00 0.00 ComputeDataSize
1.17 305.09 6.89 92337151 0.00 0.00 AllocSetFree
1.13 311.74 6.64 97183879 0.00 0.00 myFunctionCall2
1.11 318.27 6.54 155883526 0.00 0.00 MemoryContextAlloc
1.07 324.57 6.30 97183879 0.00 0.00 inlineApplySortFunction
1.05 330.75 6.17 17285775 0.00 0.00 newNode

--
greg