Re: 9.3 regression with dbt2

From: Dong Ye <yed(at)vmware(dot)com>
To: Andres Freund <andres(at)2ndquadrant(dot)com>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: 9.3 regression with dbt2
Date: 2013-12-18 20:27:08
Message-ID: CAEHKxOHV6V_x+zsq4WspQw99qSDHFrGMe=RjTqTCuaJzDHhXWQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hi,

Applied your patch (but not using -fno-omit-frame-pointer). It seems
recover the perf loss: 55659.72 notpm.
FWIW, the profile is below. I will do a run with the flag..
Samples: 598K of event 'cycles', Event count (approx.): 6568957160059

+ 4.03% postgres postgres [.]
hash_search_with_hash_value
+ 3.74% postgres postgres [.]
heap_hot_search_buffer
+ 3.17% postgres postgres [.] LWLockAcquire
+ 2.92% postgres postgres [.] _bt_compare
+ 2.64% postgres postgres [.] PinBuffer
+ 2.62% postgres postgres [.] AllocSetAlloc
+ 2.34% postgres postgres [.] XLogInsert
+ 2.27% postgres postgres [.] SearchCatCache
+ 1.81% postgres postgres [.]
HeapTupleSatisfiesMVCC
+ 1.52% postgres postgres [.] ExecInitExpr
+ 1.45% postgres postgres [.] heap_page_prune_opt
+ 1.41% swapper [kernel.kallsyms] [k] intel_idle
+ 1.30% postgres postgres [.] LWLockRelease
+ 1.12% postgres postgres [.] heapgetpage
+ 0.96% postgres libc-2.17.so [.] _int_malloc
+ 0.86% postgres libc-2.17.so [.] __memcpy_ssse3_back
+ 0.84% postgres postgres [.] hash_any
+ 0.81% postgres postgres [.]
MemoryContextAllocZeroAligned
+ 0.76% postgres postgres [.] XidInMVCCSnapshot
+ 0.74% postgres postgres [.] _bt_checkkeys
+ 0.70% postgres postgres [.]
fmgr_info_cxt_security
+ 0.70% postgres postgres [.] FunctionCall2Coll
+ 0.66% postgres libc-2.17.so [.]
__strncpy_sse2_unaligned
+ 0.63% postgres postgres [.] tbm_iterate
+ 0.58% postgres postgres [.] base_yyparse
+ 0.58% postgres libc-2.17.so [.] __printf_fp
+ 0.55% postgres postgres [.] palloc
+ 0.51% postgres postgres [.]
TransactionIdPrecedes
+ 0.51% postgres postgres [.] slot_deform_tuple
+ 0.50% postgres postgres [.] ReadBuffer_common

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Marko Tiikkaja 2013-12-18 20:27:54 array_length(anyarray)
Previous Message Robert Haas 2013-12-18 20:23:23 Re: shared memory message queues