"anara...@anarazel.de" <and...@anarazel.de> wrote: > Kevin Grittner <kevin.gritt...@wicourts.gov> schrieb: >>samples % image name symbol name >>933394 4.9651 postgres AllocSetAlloc >>848476 4.5134 postgres base_yyparse >>719515 3.8274 postgres SearchCatCache > That profile looks like you ran pgbench with -m simple. How does > it look with prepared instead? samples % image name symbol name 495463 3.6718 postgres hash_search_with_hash_value 490971 3.6385 postgres GetSnapshotData 443965 3.2902 postgres LWLockAcquire 443566 3.2872 postgres AllocSetAlloc 302388 2.2409 postgres XLogInsert 286889 2.1261 postgres SearchCatCache 246417 1.8262 postgres PostgresMain 235018 1.7417 postgres heap_page_prune 198442 1.4706 postgres _bt_compare 181446 1.3447 postgres hash_any 177131 1.3127 postgres ExecInitExpr 175775 1.3026 postgres LWLockRelease 152324 1.1288 postgres PinBuffer 150285 1.1137 postgres exec_bind_message 145214 1.0762 postgres fmgr_info_cxt_security 140493 1.0412 postgres s_lock 124162 0.9201 postgres LockAcquireExtended 120429 0.8925 postgres MemoryContextAlloc 117076 0.8676 postgres pfree 116493 0.8633 postgres AllocSetFree 105027 0.7783 postgres pgstat_report_activity 101407 0.7515 postgres ProcArrayLockAcquire 100797 0.7470 postgres MemoryContextAllocZeroAligned 98360 0.7289 postgres ProcArrayLockRelease 86938 0.6443 postgres heap_hot_search_buffer 82635 0.6124 postgres hash_search 79902 0.5921 postgres errstart 79465 0.5889 postgres HeapTupleSatisfiesVacuum 78709 0.5833 postgres ResourceOwnerReleaseInternal 76068 0.5637 postgres ExecModifyTable 73043 0.5413 postgres heap_update 72175 0.5349 postgres strlcpy 71253 0.5280 postgres MemoryContextAllocZero tps = 27392.219364 (including connections establishing) -Kevin
-- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers