opreports.txt

text/plain

Filename: opreports.txt
Type: text/plain
Part: 0
Message: Re: dynamic SQL - possible performance regression in 9.2
==> REL9_1_7 <==
CPU: Intel Core/i7, speed 2.266e+06 MHz (estimated)
Counted CPU_CLK_UNHALTED events (Clock cycles when not halted) with a unit mask of 0x00 (No unit mask) count 100000
samples  %        image name               app name                 symbol name
701093    4.8657  postgres                 postgres                 SearchCatCache
646611    4.4876  postgres                 postgres                 AllocSetAlloc
565140    3.9222  postgres                 postgres                 hash_search_with_hash_value
466490    3.2375  postgres                 postgres                 base_yyparse
291208    2.0210  postgres                 postgres                 LWLockAcquire
232944    1.6167  postgres                 postgres                 PinBuffer
220879    1.5329  postgres                 postgres                 MemoryContextAllocZeroAligned
213494    1.4817  postgres                 postgres                 core_yylex
193402    1.3423  postgres                 postgres                 heap_hot_search_buffer
191454    1.3287  postgres                 postgres                 expression_tree_walker
191247    1.3273  postgres                 postgres                 _bt_compare
189949    1.3183  libc-2.14.1.so           libc-2.14.1.so           __strcmp_sse42
173674    1.2053  postgres                 postgres                 XLogInsert
163930    1.1377  postgres                 postgres                 FunctionCall2Coll
150816    1.0467  libc-2.14.1.so           libc-2.14.1.so           __memcpy_ssse3_back
147756    1.0255  postgres                 postgres                 tbm_iterate
146191    1.0146  postgres                 postgres                 MemoryContextAlloc
140754    0.9769  postgres                 postgres                 nocachegetattr
134809    0.9356  postgres                 postgres                 heap_page_prune_opt
124110    0.8614  postgres                 postgres                 hash_any

==> REL9_2_2 <==
CPU: Intel Core/i7, speed 2.266e+06 MHz (estimated)
Counted CPU_CLK_UNHALTED events (Clock cycles when not halted) with a unit mask of 0x00 (No unit mask) count 100000
samples  %        image name               app name                 symbol name
1086187   6.4059  postgres                 postgres                 AllocSetAlloc
773733    4.5632  postgres                 postgres                 SearchCatCache
534903    3.1546  postgres                 postgres                 base_yyparse
468215    2.7613  postgres                 postgres                 copyObject
413929    2.4412  postgres                 postgres                 MemoryContextAllocZeroAligned
387373    2.2846  postgres                 postgres                 hash_search_with_hash_value
293138    1.7288  postgres                 postgres                 expression_tree_walker
266981    1.5745  libc-2.14.1.so           libc-2.14.1.so           __memcpy_ssse3_back
260617    1.5370  libc-2.14.1.so           libc-2.14.1.so           _int_malloc
255529    1.5070  postgres                 postgres                 MemoryContextAlloc
233867    1.3793  postgres                 postgres                 core_yylex
223767    1.3197  libc-2.14.1.so           libc-2.14.1.so           __strcmp_sse42
206801    1.2196  postgres                 postgres                 _bt_compare
203589    1.2007  postgres                 postgres                 XLogInsert
200657    1.1834  postgres                 postgres                 LWLockAcquire
184643    1.0890  postgres                 postgres                 PinBuffer
171459    1.0112  postgres                 postgres                 nocachegetattr
171056    1.0088  postgres                 postgres                 FunctionCall2Coll
159389    0.9400  postgres                 postgres                 check_stack_depth
147873    0.8721  libc-2.14.1.so           libc-2.14.1.so           __strlen_sse42

==> REL9_2_2 + patch <==
CPU: Intel Core/i7, speed 2.266e+06 MHz (estimated)
Counted CPU_CLK_UNHALTED events (Clock cycles when not halted) with a unit mask of 0x00 (No unit mask) count 100000
samples  %        image name               app name                 symbol name
966153    5.1987  postgres                 postgres                 SearchCatCache
908404    4.8880  postgres                 postgres                 AllocSetAlloc
625522    3.3658  postgres                 postgres                 base_yyparse
476507    2.5640  postgres                 postgres                 hash_search_with_hash_value
287013    1.5444  postgres                 postgres                 MemoryContextAllocZeroAligned
284729    1.5321  postgres                 postgres                 core_yylex
281957    1.5172  postgres                 postgres                 expression_tree_walker
273250    1.4703  postgres                 postgres                 XLogInsert
258647    1.3917  postgres                 postgres                 _bt_compare
251712    1.3544  postgres                 postgres                 LWLockAcquire
251396    1.3527  libc-2.14.1.so           libc-2.14.1.so           __strcmp_sse42
230653    1.2411  postgres                 postgres                 PinBuffer
213339    1.1479  postgres                 postgres                 FunctionCall2Coll
210845    1.1345  libc-2.14.1.so           libc-2.14.1.so           __memcpy_ssse3_back
205990    1.1084  postgres                 postgres                 MemoryContextAlloc
201418    1.0838  postgres                 postgres                 nocachegetattr
186821    1.0053  postgres                 postgres                 heap_hot_search_buffer
172356    0.9274  libc-2.14.1.so           libc-2.14.1.so           _int_malloc
167646    0.9021  postgres                 postgres                 fmgr_info_cxt_security
155884    0.8388  postgres                 postgres                 lappend