Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id AF5F947648B for ; Thu, 16 Jan 2003 01:11:50 -0500 (EST) Received: from sss.pgh.pa.us (unknown [192.204.191.242]) by postgresql.org (Postfix) with ESMTP id 0C14F4764A7 for ; Thu, 16 Jan 2003 01:11:49 -0500 (EST) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.12.6/8.12.6) with ESMTP id h0G6Bm5u012203; Thu, 16 Jan 2003 01:11:48 -0500 (EST) To: captainx0r@yahoo.com Cc: pgsql-performance@postgresql.org Subject: Re: Sun vs. Mac - gprof output In-reply-to: <20030115172250.54953.qmail@web21110.mail.yahoo.com> References: <20030115172250.54953.qmail@web21110.mail.yahoo.com> Comments: In-reply-to CaptainX0r message dated "Wed, 15 Jan 2003 09:22:50 -0800" Date: Thu, 16 Jan 2003 01:11:48 -0500 Message-ID: <12202.1042697508@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200301/134 X-Sequence-Number: 781 CaptainX0r writes: > % cumulative self self total > time seconds seconds calls ms/call ms/call name > 15.8 111.61 111.61 rl_signal_handler [5] > 4.3 142.18 30.57 rl_sigwinch_handler [6] > 1.9 155.42 13.24 rl_set_sighandler [8] > 1.9 168.52 13.10 rl_maybe_set_sighandler > [9] > 1.1 176.37 7.85 _rl_next_macro_key [11] > 0.9 182.38 6.01 rl_read_key [12] > 0.8 188.07 5.69 rl_backward_kill_line [13] All of these names correspond to internal routines in libreadline. 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. regards, tom lane