Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 260C1650222 for ; Sun, 24 Aug 2008 23:30:03 -0300 (ADT) Received: from postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 88802-02-4 for ; Sun, 24 Aug 2008 23:29:49 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from lists.commandprompt.com (host-159.commandprompt.net [207.173.203.159]) by postgresql.org (Postfix) with ESMTP id 4FDFA65049C for ; Sun, 24 Aug 2008 23:16:26 -0300 (ADT) Received: from perhan.alvh.no-ip.org (190-95-19-36.bk17-dsl.surnet.cl [190.95.19.36]) (authenticated bits=0) by lists.commandprompt.com (8.13.8/8.13.8) with ESMTP id m7P2JDvF015507 (version=TLSv1/SSLv3 cipher=DHE-RSA-AES256-SHA bits=256 verify=NO); Sun, 24 Aug 2008 19:19:18 -0700 Received: by perhan.alvh.no-ip.org (Postfix, from userid 1000) id 4DF1E47C9B; Sun, 24 Aug 2008 22:16:09 -0400 (CLT) Date: Sun, 24 Aug 2008 22:16:09 -0400 From: Alvaro Herrera To: Tom Lane Cc: Scott Carey , Craig Ringer , Peter Schuller , pgsql-performance@postgresql.org Subject: Re: Identifying the nature of blocking I/O Message-ID: <20080825021609.GF4506@alvh.no-ip.org> References: <20080822115243.GA10981@hyperion.scode.org> <48B1FD1A.7040807@postnewspapers.com.au> <1028.1219628991@sss.pgh.pa.us> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <1028.1219628991@sss.pgh.pa.us> User-Agent: Mutt/1.5.18 (2008-05-17) X-Greylist: Sender succeeded SMTP AUTH, not delayed by milter-greylist-4.0 (lists.commandprompt.com [207.173.203.159]); Sun, 24 Aug 2008 19:19:20 -0700 (PDT) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests=none X-Spam-Level: X-Archive-Number: 200808/319 X-Sequence-Number: 31200 Tom Lane wrote: > "Scott Carey" writes: > > DTrace is available now on MacOSX, Solaris 10, OpenSolaris, and FreeBSD. > > Linux however is still in the dark ages when it comes to system monitoring, > > especially with I/O. > > Oh, after poking around a bit, I should note that some of my Red Hat > compatriots think that "systemtap" is the long-term Linux answer here. > I know zip about it myself, but it's something to read up on if you are > looking for better performance monitoring on Linux. FWIW there are a number of tracing options on Linux, none of which is said to be yet at the level of DTrace. See here for an article on the topic: http://lwn.net/Articles/291091/ -- Alvaro Herrera http://www.CommandPrompt.com/ The PostgreSQL Company - Command Prompt, Inc.