X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 2142F53AE8 for ; Thu, 7 Apr 2005 00:23:15 +0100 (BST) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 39959-05 for ; Wed, 6 Apr 2005 23:23:06 +0000 (GMT) Received: from castle.comp.uvic.ca (castle.comp.uvic.ca [142.104.5.97]) by svr1.postgresql.org (Postfix) with ESMTP id C123E53A39 for ; Thu, 7 Apr 2005 00:23:04 +0100 (BST) Received: from [127.0.0.1] (bkbox.idc.uvic.ca [142.104.12.33]) by castle.comp.uvic.ca (8.13.2/8.13.2) with ESMTP id j36NMx7t7610510 for ; Wed, 6 Apr 2005 16:23:07 -0700 Message-ID: <42546F53.1020300@aers.ca> Date: Wed, 06 Apr 2005 16:22:59 -0700 From: Adam Palmblad User-Agent: Mozilla Thunderbird 1.0 (Windows/20041206) X-Accept-Language: en-us, en MIME-Version: 1.0 To: "pgsql-performance@postgresql.org" Subject: Tweaking a C Function I wrote Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-UVic-Virus-Scanned: OK - Passed virus scan by Sophos (sophie) on castle X-UVic-Spam-Scan: castle.comp.uvic.ca Not_scanned_LOCAL X-Scanned-By: MIMEDefang 2.33 (www . roaringpenguin . com / mimedefang) X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.291 tagged_above=0 required=5 tests=AWL, TO_ADDRESS_EQ_REAL X-Spam-Level: X-Archive-Number: 200504/132 X-Sequence-Number: 11529 I wanted to see if I could squeeze any more performance out of a C set returning function I wrote. As such, I looked to a profiler. Is it possible to get profile information on the function I wrote? I've got postmaster and my function compiled with profiling support, and can find the gmon.out files... can I actually look at the call tree that occurs when my function is being executed or will I be limited to viewing calls to functions in the postmaster binary? -Adam