Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id E716847621F for ; Thu, 16 Jan 2003 08:44:59 -0500 (EST) Received: from web21105.mail.yahoo.com (web21105.mail.yahoo.com [216.136.227.107]) by postgresql.org (Postfix) with SMTP id 574DC47621A for ; Thu, 16 Jan 2003 08:44:59 -0500 (EST) Message-ID: <20030116134502.36697.qmail@web21105.mail.yahoo.com> Received: from [140.247.91.110] by web21105.mail.yahoo.com via HTTP; Thu, 16 Jan 2003 05:45:02 PST Date: Thu, 16 Jan 2003 05:45:02 -0800 (PST) From: CaptainX0r Reply-To: captainx0r@yahoo.com Subject: Re: Sun vs. Mac - gprof output To: pgsql-performance@postgresql.org In-Reply-To: <12202.1042697508@sss.pgh.pa.us> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200301/141 X-Sequence-Number: 788 > 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 [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 [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 [34] 2.1 397.46 11.49 79296415 0.00 0.00 ExecEvalFuncArgs [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 [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 [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