Received: from maia.hub.org (maia-5.hub.org [200.46.204.29]) by mail.postgresql.org (Postfix) with ESMTP id B0DAA1337999 for ; Mon, 3 Jan 2011 12:17:27 -0400 (AST) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.29]) (amavisd-maia, port 10024) with ESMTP id 60911-01 for ; Mon, 3 Jan 2011 16:17:20 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from lpo-relay-04.vmsinfo.com (lpo-relay-04.vmsinfo.com [216.169.137.115]) by mail.postgresql.org (Postfix) with ESMTP id 3F7401336971 for ; Mon, 3 Jan 2011 12:17:20 -0400 (AST) X-IronPort-AV: E=Sophos;i="4.60,267,1291611600"; d="scan'208";a="27810145" Received: from unknown (HELO lpo-mailbox-02.vmsinfo.com) ([216.169.137.251]) by lpo-relay-04.vmsinfo.com with ESMTP; 03 Jan 2011 11:17:19 -0500 Received: from [10.101.43.35] (lpo-autonomy-p03.vmsinfo.com [216.169.135.234]) by lpo-mailbox-02.vmsinfo.com (Postfix) with ESMTP id CBA1E56272; Mon, 3 Jan 2011 11:17:18 -0500 (EST) Message-ID: <4D21F68E.9070004@vmsinfo.com> Date: Mon, 03 Jan 2011 11:17:18 -0500 From: Mladen Gogala Organization: VMS User-Agent: Thunderbird 2.0.0.24 (X11/20101027) MIME-Version: 1.0 To: Jim Nasby CC: James Cloos , Royce Ausburn , "pgsql-performance@postgresql.org" Subject: Re: CPU bound References: <4D0EFC02.7040004@vmsinfo.com> <5509F55C-FA66-4813-89C3-B2E62F6E8F49@Nasby.net> In-Reply-To: <5509F55C-FA66-4813-89C3-B2E62F6E8F49@Nasby.net> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.91 tagged_above=-10 required=5 tests=BAYES_00=-1.9, T_RP_MATCHES_RCVD=-0.01 X-Spam-Level: X-Archive-Number: 201101/4 X-Sequence-Number: 41791 Jim Nasby wrote: > On Dec 20, 2010, at 12:47 AM, Mladen Gogala wrote: > >> Good time accounting is the most compelling reason for having a wait event interface, like Oracle. Without the wait event interface, one cannot really tell where the time is spent, at least not without profiling the database code, which is not an option for a production database. >> > > Out of curiosity, have you tried using the information that Postgres exposes to dtrace? I suspect it comes close to what you can get directly out of Oracle... > -- > Jim C. Nasby, Database Architect jim@nasby.net > 512.569.9461 (cell) http://jim.nasby.net > > > > No, I haven't but I looked it in the documentation. I surmise, however, that I will have to build my software with "--enable-dtrace", which is not enabled by default. This certainly looks promising. -- Mladen Gogala Sr. Oracle DBA 1500 Broadway New York, NY 10036 (212) 329-5251 http://www.vmsinfo.com The Leader in Integrated Media Intelligence Solutions